Thread: Excel 2003, which formula will count the cells that meet 2 conditi
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mikeopolo
 
Posts: n/a
Default Excel 2003, which formula will count the cells that meet 2 conditi

I think the sumproduct formula posted above should have read:

=SUMPRODUCT(--(Sheet1!B1:B1000="Move-In")*--(Sheet1!E1:E1000 = "A1"))

Rgds
Mike


--
Mikeopolo
------------------------------------------------------------------------
Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570
View this thread: http://www.excelforum.com/showthread...hreadid=525709

Reply With QuoteReply With Quote