ReferenceFunctionsMath Functions
SUMIFS
SUMIFS: Adds values that satisfy multiple criteria.
Summary
SUMIFS applies all criteria pairs with logical AND and sums the matching cells.
Remarks
- The first argument is always the sum target range.
- Criteria are supplied in
(criteria_range, criteria)pairs. - Criteria ranges are broadcast/padded according to engine matching rules.
Examples
Sum with two conditions
Grid
| Cell | Value | |
|---|---|---|
Formula
=
Result
Not evaluated yet.
Expected
20
Numeric criteria on single range
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
30
No matching rows yields zero
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0
Related functions
FAQ
How are multiple SUMIFS criteria combined?
All criteria pairs are applied with logical AND; every condition must match.
What if criteria range sizes differ?
Ranges are broadcast/padded under engine rules instead of strict Excel-size rejection.
Runtime metadata
Category
Math
Signature
SUMIFS(arg1, arg2, ... argN: Any)This function accepts a repeating argument pattern (min args: 3).
Arity
min 3, max variadic
Arguments
arg1Any · Scalar
Caps
PUREREDUCTIONWINDOWEDSTREAM_OKPARALLEL_ARGSPARALLEL_CHUNKS
Source