| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average formula Counting zero's How do I get just the numers counted.
Spreadsheet is created for a layover from other sources, therefore,
zeros will be present when data is laid on top of master spreadsheet. Also, want to show no values by using a "-" when no numbers present for easy recognition. Current formula is =IF(SUM(D9:GU9)=0,"-", (AVERAGE(D9:GU9))) but if two numbers and a zero are present it averages by three. Can anyone HELP????? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Average formula Counting zero's How do I get just the numers count
what if you used "" instead of "-"? this would display nothing in the cell
instead of a "-". " wrote: Spreadsheet is created for a layover from other sources, therefore, zeros will be present when data is laid on top of master spreadsheet. Also, want to show no values by using a "-" when no numbers present for easy recognition. Current formula is =IF(SUM(D9:GU9)=0,"-", (AVERAGE(D9:GU9))) but if two numbers and a zero are present it averages by three. Can anyone HELP????? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average formula Counting zero's How do I get just the numers counted. | Excel Discussion (Misc queries) | |||
| Excluding Zero's from Average (SumIF / CountIF) | Excel Worksheet Functions | |||
| =SUMPRODUCT formula is counting the blank cells as well as zero's | Excel Worksheet Functions | |||
| =SUMPRODUCT formula is counting the blank cells as well as zero's | Excel Worksheet Functions | |||
| Average Non-Continuous Cells Without Zero's | Excel Worksheet Functions | |||
Linear Mode
