AVERAGEIFS()

This article is also available in: Bahasa Malaysia Bahasa Indonesia

AVERAGEIFS() is similar to AVERAGEIF() except that you can provide multiple criteria instead of just one .

AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

average_range – the range of values from which you want to calculate the average

criteria_range1 – the range where you want to check for the first condition or criteria

criteria1 – this is the condition or criteria you want to check

To specify more conditions or criteria you want to check, use criteria_range2, criteria2, and so on.

The maximum number of criteria_range and criteria you can include depends on the version of Excel you have.

For versions up to Excel 2019, it was 127, but since Excel 2021, as well as for those included in the Microsoft 365 subscription, the limit is 255.

This article is also available in: Bahasa Malaysia Bahasa Indonesia