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.

--
Andy.


"KJA" wrote in message
...
I'd like to count the number of values whe

Column A equals X
AND
Column B equals y

(for any given row)

Is this possible?