Export (0) Print
Expand All
Expand Minimize

2.1.878 Part 1 Section 18.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:
© 2014 Microsoft