View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FC FC is offline
external usenet poster
 
Posts: 130
Default 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.