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)))
Bookmarks