sum if - null values

[Guest]

I want to sum a range where the data I'm evaluating contains some cells with
no entries. The following formula doesn't work and returns the sum of the
total sum_range:

=SUMIF(A25:A30,"<>""",B25:B30)

(Where B25:B30 contains values and cells with no entries. I want the sum of
those cells with values)

If I remove the quotation marks around the 'not equal to' sign Excel returns
an error message.

 

[Roger Govier]

Hi

Try
=SUMIF(A25:A30,"<>",B25:B30)