Don't show repeated totals when not adding

F

FC

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.
 
D

Don Guillett

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