and for details on how the SUMPRODUCT function works check out
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
Cheers
JulieD
check out
www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
<Andy B wrote in message ...
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?