rbrychckn,

No, I messed up - it returns 4 no matter what:

=SUMPRODUCT((A2:D2<"")*1)

will work, however.

Bernie


"rbrychckn" wrote
in message ...

Ah. I didn't realize you could create such a argument in a countif (eg.
"<""")

This doesn't work, however, in my sheet. I'm using Excel 2000 - was
this function syntax added after?


--
rbrychckn
------------------------------------------------------------------------
rbrychckn's Profile:
http://www.excelforum.com/member.php...fo&userid=4024
View this thread: http://www.excelforum.com/showthread...hreadid=437392