Sumproduct Question

  • Thread starter Thread starter JimS
  • Start date Start date
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.
 
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?
 
It's because you have text in J17:J3000

this will ignore text

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

--


Regards,


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