Loading…
Loading…
The IFS family goes beyond sums and counts. AVERAGEIF averages the rows that meet one condition and AVERAGEIFS several. MAXIFS and MINIFS return the largest or smallest value that meets your conditions. Like SUMIFS, the range you calculate on comes first, then pairs of range and criteria.
Syntax
AVERAGEIFS(avg_range, range1, criteria1, …) · MAXIFS(max_range, range1, criteria1, …) · MINIFS(…)
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.