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.


Did you find this article helpful? Please rate and also share your thoughts in the comments section below.

0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Most Voted
Newest Oldest
Inline Feedbacks
View all comments

Excel AVERAGEIF() function

AVERAGEIF()

Excel COUNT() function

COUNT()