The Excel AVERAGEIFS function calculates the average of numbers in a range that meet one or more criteria. The criteria used for AVERAGEIFS can include logical operators (>,<,<>,=) and wildcards (*,?) for partial matching.
- Purpose: Average cells that match multiple criteria
- Return value: The average of the cells that meet all criteria
Syntax
=AVERAGEIFS (avg_rng, range1, criteria1, [range2], [criteria2], ...)
Arguments
- avg_rng - The range to average.
- range1 - The first range to evaulate.
- criteria1 - The criteria to use on range1.
- range2 - [optional] The second range to evaluate.
- criteria2 - [optional] The criteria to use on range2.