Formula error

A

Anthony

Hi,

I'm new (still) so I'm sure this is easy, but I can't suss it.

I have this formula to add the total sum (in £) from certain cells. The
problem is if some of the cells have no value in them I get an error #value

my formula is : =IF(ISBLANK(K4),"",SUM(R4+R6+R8+R11+R14+P17))

any help apreciated
 
D

Dave O

If one of the cells in the SUM range accidentally has a blank space
entered, you'll get that value.
 
D

Dave Peterson

And I bet that at least one of those cells wasn't really blank.

(It may have contained text (even a single space character).)

=sum() ignores cells with text.
But =a1+b1+c1 will cause errors if there's text in one of those cells.

(=sum() doesn't need those +'s either.)
 
Top