can someone help me with this formula

  • Thread starter Thread starter Gary Keramidas
  • Start date Start date
G

Gary Keramidas

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:C3>1,C3:C33))

=SUMPRODUCT(B3:B33="")*(C3:C33>1)
 
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:C33>1))
 
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:C33>1))
 
thanks for that, tom

--


Gary


Tom Ogilvy said:
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:C33>1))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top