COUNTIF Statement with Multiple Conditions in Different Ranges

K

KJA

I'd like to count the number of values where:

Column A equals X
AND
Column B equals y

(for any given row)

Is this possible?
 
G

Guest

Hi
You'll need to use SUMPRODUCT() for this. eg:
=SUMPRODUCT((A2:A1000="X")*(B2:B1000="Y"))
You cannot use full column references eg A:A and the references you do use
must be the same size.
 
Top