SUMIFS function


Sums cells that match multiple criteria.



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


required arguments:

sum_range The range to be summed.
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.