=SUMPRODUCT((A1:A3=1)*(B1:B3=2))
Vaya con Dios,
Chuck, CABGx3
"Lee" wrote in message
...
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
|