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