COUNTIF Statement with Multiple Conditions in Different Ranges

[Guest]

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?

 

[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.

 

[JulieD]

and for details on how the SUMPRODUCT function works check out
http://www.xldynamic.com/source/xld.SUMPRODUCT.html