Hi all, as title basically.
I have values in cells C9:L9 and i want these to be added. I can do this with normal Sum formula. HOwever what i want is that if the cells are blank then the formula in cell A9 should be blank aswell. However i am getting a #VALUE error.
In cells C9:L9 the values are made up from formulas so these cells already have formulas.
The formula works fine if the cell has values in it but as soon as there is a blank then i get the #Value error.
I have tried the following:
IF(ISBLANK(C9:L9),"",SUM(C9+D9+E9+F9+G9+H9+I9+J9+K9+L9))
This works if there are values in C9:L9 but returns #Value error if they are blank
Any help please
Bookmarks