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