And I forget to preceede the second comparision with -- . So the correct
formula must be
=SUMPRODUCT(--($A$5:$A$50<""),--($B$5:$B$50=""))


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



"starguy" wrote in
message ...

what is the role of -- in this formula and others.


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