| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding totals to new sheet | Excel Worksheet Functions | |||
| adding up number of repeated names | Excel Discussion (Misc queries) | |||
| how do I show 1st, 2nd, and 3rd most repeated non-numeric values? | Excel Worksheet Functions | |||
| Adding totals after filtering | Excel Discussion (Misc queries) | |||
| can i show repeated values in a pivot table? | Excel Discussion (Misc queries) | |||
Linear Mode
