| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average a set of figures which ignores 0 entries
I need to average the figures in several cells. However some cells have a 0
in them. I therefore want the formula to ignore the cells which have a zero. I have used the AVERAGE & AVERAGEA function, but both count 0 cells. (although AVERAGEA ignores blank cells, I need to keep the 0s in as they are linked to another formula) Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| plotted Average | Charts and Charting in Excel | |||
| What is this kind of average called? | Excel Worksheet Functions | |||
| Average of column entries | Excel Discussion (Misc queries) | |||
| Any way to calculate an average for more than 30 entries? | Excel Worksheet Functions | |||
| How do i get an average that ignores blanks in the range of cells. | Excel Worksheet Functions | |||
Threaded Mode
