description:
Returns the average (arithmetic mean) of its arguments specified by a given set of criteria. |
syntax:
=SUMIFS( sum_range, criteria_range1, criteria1, [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. |