| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Averaging ranges
I am looking to average a range of numbers, but I want to exclude any cell that has a zero from the Average. In this particular case, the zero's are filler only and have no real meaning but they are distorting my figure. I can't seem to find the magic formula to make it function. Brian |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| averaging ranges | Excel Discussion (Misc queries) | |||
| Averaging two ranges on the same column (excluding zeros) | Excel Worksheet Functions | |||
| how copy formula that contains ranges so ranges do not overlap | Excel Worksheet Functions | |||
| Averaging multiple ranges with #n/a values | Excel Discussion (Misc queries) | |||
| named ranges - changing ranges with month selected | Excel Programming | |||
Threaded Mode
