I'm assuming you are using XL2003 or earlier. If so, you cannot use whole
column (such as A:A) references within the SUMPRODUCT function... you have
to specify a fixed range and all ranges should be the same length (there are
some exceptions to this, but not for the simple ranges you are using). So,
try something like this...

=SUMPRODUCT((A2:A1000="xxx")*(B2:B1000=""))

--
Rick (MVP - Excel)



"Nadine" wrote in message
...
Unfortunately I got the result #NUM!. Thanks for trying.

"Max" wrote:

Something like this: =sumproduct((ColA="xxx")*(ColB=""))
--
Max
Singapore
---
"Nadine" wrote:
I need to count the number of items in ColA that match a certain
criteria in
ColA and are blank in ColB. Any ideas?
Thanks.
Nadine