My current array forula does work:
=SUM(IF((DRESS!$A$2:$A$1000=A16)*(DRESS!$E$2:$E$10 00<""),1))
--
JR573PUTT
------------------------------------------------------------------------
JR573PUTT's Profile:
http://www.excelforum.com/member.php...o&userid=31587
View this thread:
http://www.excelforum.com/showthread...hreadid=513399