| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Average, Excluding Zeros, Non-Consecutive Range
I am trying to average a range of numbers (F35:F38,F42:F45,F48:F54) that have
numeric zeros in some of the cells. However, I would like to exclude them, and the cells from the calculation. Why does this array not work? =AVERAGE(IF((F35:F38,F42:F45,F48:F54)<0,(F35:F38, F42:F45,F48:F54))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| average of visible cells in a filtered range | Excel Worksheet Functions | |||
| Average non continguous cells, excluding zero's | Excel Worksheet Functions | |||
| Can I sum or average a range with more than 1 condition? | Excel Discussion (Misc queries) | |||
| EXcluding Zeros from the average in a row | Excel Discussion (Misc queries) | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Threaded Mode
