I want to know how many times 2 corresponding cells meet a conditi
=SUMPRODUCT(--(A1:A5=1),--(B1:B5=2))
Or
=SUMPRODUCT(--(A1:A5=C1),--(B1:B5=D1))
where C1=1, D1=2
"talderman" wrote:
I have 2 columns of numbers I would like to know how many times the value in
column A meets a certain value in column B.
ex)
column A column B
row1 1 2
row2 1 2
row3 1 2
How many times does the value 1 in column A match the corrspond value of 2
in column B. For clarity in this example it occurs 3 times?
--
Tim
|