Leave cell blank until data is posted

I would like to do a sum to different cell but only if data is entered. If data is not enter then I want that cell to be blank. My formula below gives me #value! when I don't have value in the cells. The data is supposed to be diagonally but it doesn't look correct when I posted so I have to have the data going down.

Ex:

A1=2
B1=4
C1=5
D1=8

Total is 19


My formula is =IF(AND(A1="",B1="",C1="",D1="",E1=""),"",SUM(A1+B1+C1+D1+E1))

thanks

Here's one way...

=IF(COUNT(A1:E1)<5,"",SUM(A1:E1))

Try:

Formula:

Please Login or Register  to view this content.

Tony and I have taken slightly different approaches. With mine, if all the cells are blank, you get a blank. Otherwise it sums what is there. With Tony's approach, if any cells are blank, you get a blank.

Originally Posted by Philangr8

thank you Tony but I should have mentioned that the data cell is not in the same row or column. It is spread out in different cells so it won't work.

Then tell us what the REAL cells are.

Then

Formula:

Please Login or Register  to view this content.

So

Formula:

Please Login or Register  to view this content.

Ok, this emulates your current formula:

=IF(COUNT(A1,A7,A10,A17)=0,"",SUM(A1,A7,A10,A17))

Originally Posted by phuocam

...sum(a1,b1,c1,d1,e1))

sum(a1:e1)

You're welcome. Thanks for the feedback!