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.

Hi

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


--
Regards

Roger Govier


"DC" wrote in message
...
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.