Sumproduct Question

[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.

 

[muddan madhu]

Is there any text in the range J17:J3000 ?

 

[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?

 

[Peo Sjoblom]

It's because you have text in J17:J3000

this will ignore text

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

--


Regards,


Peo Sjoblom

 

[JimS]

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

 

[JimS]

Very cool. I didn't know that. Thanks