2.1.887 Part 1 Section 18.17.7.20, AVERAGEIF

  • Article

a.   The standard does not describe error case when all the cells being averaged in average-range (or in cell-range if average-range is omitted) are empty or contain non-numeric data.

Office returns #DIV/0! in this case.