Excel Function AVERAGEIF – Ways You Can Use the

Excel Function AVERAGEIF

You can use the Excel function AVERAGEIF whenever you want to have the arithmetic mean or average of every cell in a range that can meet various criteria.

What it Returns


Here, the number representing the arithmetic mean or average of the arguments gets returned.


=AVERAGEIF(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], [criteria_range3, criteria3]…).

Input Arguments

  • These are the ranges wherein you evaluate the criteria. There may be 127 ranges that have associated criteria.
  • criteria1, criteria2, criteria3, and so on… – These are the criteria that you can apply to an associated range. An example of this is criteria1 applied to criteria_range1, criteria2 is applied to criteria_range2, criteria3. They are applied to criteria_range3, and so on
  • average_range – a range of the cells you want to get the average.

Added Notes

  • Whenever the average_range has text or blanks, it will return a #DIV/0! Error.
  • The criteria can be a formula, number, cell reference, text, or expression.
    • In this criteria, you can use wildcard characters.
    • The requirements here are logical/mathematical symbols or text like the *,/,+,=, and they need to be in double-quotes.
  • Cells that have average_range can only get averaged whenever every condition is met.
  • All of the criteria_range and the average_range’s range size needs to be equal.

How to Use the AVERAGEIF Excel Function