SUMIFS()
Sums cells that meet multiple conditions at once.
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)SUMIFS works like SUMIF but supports any number of conditions, all of which must be true for a row to count — it's AND logic across every criteria pair.
Note the argument order is different from SUMIF: sum_range comes first in SUMIFS, but last in SUMIF. Mixing the two up is a common source of #VALUE! errors.
Arguments
- sum_range
- The range to sum.
- criteria_range1
- The first range to test.
- criteria1
- The condition for criteria_range1.
- criteria_range2, criteria2, ...optional
- Additional range/condition pairs — all must match.
Examples
=SUMIFS(D2:D200, A2:A200, "North", B2:B200, "2026")→142,900
Sums column D where region is North AND year is 2026.