View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JR573PUTT
 
Posts: n/a
Default Array Formula With Multiple Conditions


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