Sumproduct Question

J

JimS

This formula returns a value error:

=SUMPRODUCT((H17:H3000="3h")*(J17:J3000))

I formated both columns correctly so they are consistent.

This formula works for just the one cell.

=SUMPRODUCT((H17="3H")*(J17)

I don't understand why it works for one cell but not the whole
spreadsheet.
 
J

JimS

No text in the cells but there are some "comments." Would that be the
problem? If it is, is there a way around it, or do I have to get rid
of the comments?
 
P

Peo Sjoblom

It's because you have text in J17:J3000

this will ignore text

=SUMPRODUCT(--(H17:H3000="3h"),J17:J3000)

--


Regards,


Peo Sjoblom
 
J

JimS

In fact, I tried a much smaller range where there are no comments and
it still didn't work.
 
Top