error value, where all cells in the rangeare equal to zero.
If the argument is completely blank or contains only text values, AVERAGEIF also returns the #DIV/0!
The image below contains example formulas that use AVERAGEIF to ignore all zero values.
We’ve also included AVERAGE results to show how they differ.
Both functions use the same data, but the results differ because of the different functions.
Here’s an explanation of the results for the 4, 0, and 6 cells:
