sum if - null values
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.
|