can someone help me with this formula
 

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

can someone help me with this formula
 

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

can someone help me with this formula
 

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

can someone help me with this formula
 

=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

can someone help me with this formula
 

thanks for the clarification. just out of curiosity, is it possible to use
or with sumproduct? something like
=SUMPRODUCT(OR((B3:B33=""),(B3:B33="R"))*(C3:C331 ))

--


Gary


"Tom Ogilvy" wrote in message
...
=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

can someone help me with this formula
 

You can't use OR, you can use addition to simulate it - just like you are
doing with AND for multiplication.

=SUMPRODUCT(((B3:B33="")+(B3:B33="R")),--(C3:C331))

--
Regards,
Tom Ogilvy


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
thanks for the clarification. just out of curiosity, is it possible to use
or with sumproduct? something like
=SUMPRODUCT(OR((B3:B33=""),(B3:B33="R"))*(C3:C331 ))

--


Gary


"Tom Ogilvy" wrote in message
...
=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

can someone help me with this formula
 

thanks for that, tom

--


Gary


"Tom Ogilvy" wrote in message
...
You can't use OR, you can use addition to simulate it - just like you are
doing with AND for multiplication.

=SUMPRODUCT(((B3:B33="")+(B3:B33="R")),--(C3:C331))

--
Regards,
Tom Ogilvy


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
thanks for the clarification. just out of curiosity, is it possible to
use
or with sumproduct? something like
=SUMPRODUCT(OR((B3:B33=""),(B3:B33="R"))*(C3:C331 ))

--


Gary


"Tom Ogilvy" wrote in message
...
=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