SUMIFS
Math & trigExcel 2007Add cells that meet several conditions at once.
Syntax
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)
How it works
Note the argument order differs from SUMIF: the range to add comes first.
Examples
=SUMIFS(C:C, A:A, "North", B:B, ">="&DATE(2026,1,1))
→ North sales this year
=SUMIFS(qty, item, A2, month, B2)
→
Good to know
- All criteria_ranges must be the same size as sum_range.
- Wildcards ? and * work in text criteria.
Related functions
More Math & trig functions
Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.