SUMIFS function

description:

Sums cells that match multiple criteria.

 

syntax:

=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.