=SUMPRODUCT(--(Range1<""),--(Range2=Condition))
confounded office user Wrote:
--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile:
http://www.excelforum.com/member.php...fo&userid=4165
View this thread:
http://www.excelforum.com/showthread...hreadid=276543