Returns the average (arithmetic mean) of its arguments specified by a given set of criteria.



=SUMIFS( sum_rangecriteria_range1criteria1[criteria_range2][criteria2], … )


required arguments:

sum_range The range to average.
criteria_range1 The first range to evaluate.
criteria1 The criteria to use on criteria_range1.


optional arguments:

[criteria_range2] The second range to evaluate.
[criteria2] The criteria to use on criteria_range2.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.