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

DLL, I think the problem here is that I will not be able to maintain
historical data, only today's data. For example, when today is 4/16,
4/14 and 4/15 will 0-out. Do you agree?

Date New Prod Extension Transfer
4/14 2 0 0
4/15 0 0 0
4/16 0 0 0


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