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
AVERAGEIF in Excel
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]…).
- 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.
- 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.