Count with 2 conditions?

My data is in the following format

A B
1 2
1 0
2 0

I want to count how often there is a "1" in column A and a corresponding 2
(in the same row) in colum B

Thanks

In Column C put a formula concantenating Col A and B... = A1 & B1
Copy this down your list
In D1 put the formula...
=COUNTIF(C:C,"12")

HTH,
Gary Brown


"Lee" <Lee@discussions.microsoft.com> wrote in message
news:4CC2990C-FDD3-43B0-BF6E-922D37DDB027@microsoft.com...
> My data is in the following format
>
> A B
> 1 2
> 1 0
> 2 0
>
> I want to count how often there is a "1" in column A and a corresponding 2
> (in the same row) in colum B
>
> Thanks

=SUMPRODUCT((A1:A3=1)*(B1:B3=2))

Vaya con Dios,
Chuck, CABGx3


"Lee" <Lee@discussions.microsoft.com> wrote in message
news:4CC2990C-FDD3-43B0-BF6E-922D37DDB027@microsoft.com...
> My data is in the following format
>
> A B
> 1 2
> 1 0
> 2 0
>
> I want to count how often there is a "1" in column A and a corresponding 2
> (in the same row) in colum B
>
> Thanks