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.