Hi

SUMPRODUCT(--($A$5:$A$50<""),($B$5:$B$50=""))


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"starguy" wrote in
message ...

I want to count nonblank cells in A5:A50 if corresponding cells in
B5:B50 are blank.


--
starguy
------------------------------------------------------------------------
starguy's Profile:
http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=535422