SUMIFS
Description
Adds the numbers specified in the sum_range, if a set of criteria are met.
Syntax
SUMIFS(
sum_range
,
range
,
criteria
, [
range2
,
criteria2
], ...)
- sum_range: The range of values, or values in cells, to sum if all criteria are met.
- range: The range of values, or cells, to test.
- criteria: The condition to test each value against.
- range2: The range of values, or cells, to test.
- criteria2: The condition to test each value against.