kieffer Wrote:
{=COUNT(IF((NewProduct2006!$C$9:$C$2000="New
Prod"),(NewProduct2006!$H$7:$H$2000="In
Process"),(NewProduct2006!$E$1=$A3)))}

This forumal is presently giving me a 0 value.

Does anyone see an issue with this formula?


Yes,

The syntax isn't quite right and the ranges should probably be the same
size. Perhaps

=COUNT(IF((NewProduct2006!$C$9:$C$2000="New
Prod")*(NewProduct2006!$H$9:$H$2000="In
Process")*(NewProduct2006!$E$1=$A3),1))

confirmed with CTRL+SHIFT+ENTER

although I'd be inclined to use SUMPRODUCT and re-arrange slightly

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

only requires ENTER


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