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.