Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Re: Simple COUNTIF function help
10 views
Skip to first unread message
Message has been deleted
Kevin@Radstock
Nov 2, 2012, 3:29:39 AM11/2/12
to
Hi
One way. assuming your data is in A1:C5. In E1:E3 allocate your values
x, y, z. Then in F1: =SUM(IF($B$1:$B$5=$C$1:$C$5,1)*($A$1:$A$5=E1)). CSE
& copy down.
zctpec3;1606965 Wrote:
> Following problem:
>
> x 4 4
> x 1 2
> y 4 3
> y 3 2
> z 3 3
>
> I am trying to count the number of times a value in column 2 matches the
> value in column 3, given a value in column 1. I.e. if column1=x, the
> result should be 1. if column1=y, the result should be 0, etc.
>
> Could you please help solve this problem? I have to apply it to a
> spreadsheet with thousands of entries..
>
> Thanks!
--
Kevin@Radstock
joeu2004
Nov 2, 2012, 3:59:14 AM11/2/12
to
"zctpec3" <zctpec3...@excelbanter.com> wrote:
> Following problem:
> x 4 4
> x 1 2
> y 4 3
> y 3 2
> z 3 3
> I am trying to count the number of times a value in
> column 2 matches the value in column 3, given a value
> in column 1. I.e. if column1=x, the result should be 1.
> if column1=y, the result should be 0, etc.
=SUMPRODUCT(($A$1:$A$1000="x")*($B$1:$B$1000=$C$1:$C$1000))
> Following problem:
> x 4 4
> x 1 2
> y 4 3
> y 3 2
> z 3 3
> I am trying to count the number of times a value in
> column 2 matches the value in column 3, given a value
> in column 1. I.e. if column1=x, the result should be 1.
> if column1=y, the result should be 0, etc.
Of course, you can replace "x" with a reference to a cell with that value.
0 new messages