=COUNT(IF((NewProduct2006!$C$9:$C$2000="New
Prod")*(NewProduct2006!$H$9:$H$2000="In
Process")*(NewProduct2006!$E$1=$A3),1))
I'm still getting a 0 value.
Criteria:
1. Column C contains 3 choices, in this case I want to count if it is
New Prod
2. Column H contains 3 choices, in this case I want to count if it is
In Process
3. $E$1 is actually a cell that contains today's date. A3 contains each
day of the year. Therefore, as today's date changes, it will sum to a
different row.
--
kieffer
------------------------------------------------------------------------
kieffer's Profile:
http://www.excelforum.com/member.php...o&userid=30848
View this thread:
http://www.excelforum.com/showthread...hreadid=533060