I'm trying to add four non consecutive cells A2, A4, A6, A8 and A11 in cell A12. I want A12 to remain blank until the data in
A2,A4,A6,A8 is inputted. Currently I'm getting either a $0.00 or =Value in cell A12.

Current formula is =IF(ISBLANK(A2,A4,A6,A8),"",A11+(A2+A4+A6+A8))

In a nutshell I need a formula to to leave the sum cell blank until there is data in all the cells that it is adding up.


Thanks in advance,

Rustin