Add up cells that meet multiple conditions at once.
Syntax
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)Arguments
sum_rangerequired
The cells to add.
criteria_range1required
The first range to test.
criteria1required
The first condition.
criteria_range2…optional
Additional range/criteria pairs.
SUMIFS totals values that satisfy every criterion you supply — for example, sales in the East region during Q1 above $500. Note the sum range comes first, then each criteria range/criteria pair.
=SUMIFS(C2:C100, B2:B100, "East", D2:D100, ">500")→$31,200Sums sales where region is East AND amount exceeds 500.
Put the sum range first
Unlike SUMIF, the column you total comes first in SUMIFS.
Add condition pairs
Supply each criteria range followed by its condition.
Keep ranges the same size
All ranges must span the same rows or SUMIFS errors.
Yes — use two conditions on the date column, e.g. ">="&start and "<="&end, to sum within a window.