Thread: Count If 3 Criteria Met
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs
 
Posts: n/a
Default Count If 3 Criteria Met

OK, so you're copying the formula down a number of rows and you want it
to give a count only on the row that contains today's date? In that
case I don't see why it wouldn't work.

Does the date match?

What happens if you try without the date criteria, what do you get
with

=SUMPRODUCT(--(NewProduct2006!$C$9:$C$2000="New
Prod"),--(NewProduct2006!$H$9:$H$2000="In Process"))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=533060

Reply With QuoteReply With Quote