2.1.915 Part 4 Section 3.17.7.20, AVERAGEIF

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.

Show: