Don't show repeated totals when not adding

[Guest]

Hi, my issue is simple.
A

1 26.00 My formula adds A1+A2
A3+A4
2 4.00 and so on as I filled the even numbers.

3 30.00 In this example when I

4 2.00 have not put value in

5 32.00 A6 yet I want A7 "BLANK" too.

6

7 32.00

Thanks in advance.

 

[Don Guillett]

How about this to give nothing until both are filled?
=IF(COUNT(a1:a2)<2,"",a1+a2)

 

[Guest]

That did it! Thanks Don Guillett

How about this to give nothing until both are filled?
=IF(COUNT(a1:a2)<2,"",a1+a2)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Don Guillett]

Glad to help