The AVERAGEIF function makes it easier to find the average value in a range of data that meets a certain criterion. One use of the function is to ignore zero values in data that would disrupt the average or arithmetic mean when using the normal AVERAGE function. In addition to data added to a worksheet, zero values can result from formula calculations, especially in incomplete worksheets.
Calculate Average Excluding Zero – Excel AVERAGEIF Function
The image below shows an example function that uses AVERAGEIF to ignore all zero values. All of the functions shown use the same basic formula with only the range changing between examples. The different results are due to the different data used in the formula.
The criterion in the formula that allows zeros to be ignored is:
The syntax of a function refers to the layout of the function and includes the function name, parentheses, and arguments. The syntax for the AVERAGEIF function is:
