=SUMPRODUCT((B3:B33="")*(C3:C331))

worked fine. You had a typo.

--
Regards,
Tom Ogilvy


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
thanks norman, almost had it right.<g

--


Gary


"Norman Jones" wrote in message
...
Hi Gary,

Try:

=SUMPRODUCT(ISBLANK($B$3:$B$33)*($C$3:$C$331))


---
Regards,
Norman



"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
for columns b and c, if b is blank and c 1, i want the count for
column
c.

i tried these to no avail

=COUNT(IF(B3:B33="",C3:C31,C3:C33))

=SUMPRODUCT(B3:B33="")*(C3:C331)
--


Gary