| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averages excluding zeros
Is there a way to average a column of numbers, but have Excel ignore "0"s?
For example if my column is: 2 3 4 0 1 0 Excel will average this as 1.67 (sum of 10 divided by 6 entries) , but what I need is 2.5 ( Sumof 10 divided by 4 non-zero entries.) Bonus Question: Is there a way to create this effect in a Pivot Table? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Averages but excluding zero's | New Users to Excel | |||
| Excluding Zero's from Average (SumIF / CountIF) | Excel Worksheet Functions | |||
| Average, Excluding Zeros, Non-Consecutive Range | Excel Discussion (Misc queries) | |||
| Average non continguous cells, excluding zero's | Excel Worksheet Functions | |||
| EXcluding Zeros from the average in a row | Excel Discussion (Misc queries) | |||
Threaded Mode
