Summing a column with formula value...

J

Jay

The formula I have is the standard: =Sum(L35:L38), however, it generates a
"#Value!" error if cell L36 and L37 arblank or have no value. Any work
arounds out there? I know there has to be.

This formular works fine for the previous summing cell above the cell in
question: =If(Sum(L18:L34=0,"",Sum(L18:L34)), why not for the other?

Thanks
 
M

MarkN

The formula below should solve the problem:
=IF(ISERROR(SUM(L5:L38)),"",SUM(L35:L38))
The value error is likely being generated by an error in the summed range,
meaning that the summed total will return the error.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If formula 4
Using SUM(INDIRECT()) 2
Sum of values in column A based on 0/1 of column B 2
Macro/Forumula to SUM values from Sheet that does not always exist 1
sum of multiple rows 2
How do I sum cells that have values from a text formula? 4
SUMIF with criteria "<>" & "=" 4
IF Function error #VALUE 2

Top