HomeExcel Functions ► Excel AVERAGEIF Function

Syntax For Excel AVERAGEIF Function

What is the use of Excel AVERAGEIF Function?

Use Excel AVERAGEIF Function to calculate the average of the values which meet a condition. In simple words, you can specify a condition and function with only average those values which meet that condition.

Syntax for Excel AVERAGEIF Function

AVERAGEIF(range,criteria,average_range)

range A range contain values from which you want to check the condition. [Required]

criteria Condition which you want to check. [Required]

average_range A range in which you have values to calculate the average. [Optional]

More Information on Excel AVERAGEIF Function

  • All empty cells will be ignored in average_range.
  • You can use wildcard characters in criteria.
  • If range has no value or text it will return #DIV/0!.
  • Cells in the range which contain TRUE or FALSE.
  • The size of average_range and range should be same.
  • Text, logical operators should be enclosed in double quotes.
  • If you skip specifying the average range, it will return the average of cells from range (If the range has numeric values). And, if the range has other than numeric values it will return #DIV/0!.
NOTE: The AVERAGEIF function central tendency, which is the location of the center of a group of numbers in a statistical distribution.

Examples to understand Excel AVERAGEIF Function

Example For Excel AVERAGEIF Function Using Text

In above example, I have used AVERAGEIF to calculate the average of product C. I have directly inserted criteria into the function by using double quotes. In above data table, we have two entries of product C in which we have quantities 12 and 8 respectively.

AVERAGEIF Function checks for the product C in column A and average corresponding values from column B.

Example For Excel AVERAGEIF Function With Wildcards

In above example, I have used an asterisk to calculate the average quantity of fruits who have alphabet A in their name. I have two fruits in above list who have Alphabet A in their name.

AVERAGEIF Function checks from the same from column A and calculate the average of corresponding values from column B.

Download Sample File                                               

Download Sample File To Learn Excel AVERAGEIF Function

More Tips Related With Excel AVERAGEIF Function

Conclusion

Use Excel AVERAGEIF Function to average cells which meet criteria. Learn more about AVERAGEIF from here.

Related Function

Average | Averageifs

Excel Functions | Excel Formulas