| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average non-consecutive cells excluding zero
Can someone please help with construction of a formula to find an average for
cells that are in the same column but are not in the same range and may include zero values & blank rows? I am looking for something that will average only the values that are greater than zero. The cells with zero values will vary and will be separated by blank rows. For instance I would like to average column A cells in rows 1, 3, & 5 for a result of 7. Thanks. For example see below: A B C 1 6 9 2 2 0 1 4 ***Blank Row*** 3 8 0 0 4 5 2 12 ***Blank Row*** 5 0 8 10 6 3 0 11 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average Non-consecutive Cells | Excel Discussion (Misc queries) | |||
| Calculating the Average for non consecutive cells using custom for | Excel Discussion (Misc queries) | |||
| average of several cells excluding the minimum | Excel Discussion (Misc queries) | |||
| Average, Excluding Zeros, Non-Consecutive Range | Excel Discussion (Misc queries) | |||
| Average non continguous cells, excluding zero's | Excel Worksheet Functions | |||
Threaded Mode
