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