Don't show repeated totals when not adding
 

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't show repeated totals when not adding
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"FC" wrote in message
...
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't show repeated totals when not adding
 

That did it! Thanks Don Guillett

"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"FC" wrote in message
...
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't show repeated totals when not adding
 

Glad to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"FC" wrote in message
...
That did it! Thanks Don Guillett

"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"FC" wrote in message
...
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.