SUMIFS
Sum values that meet multiple conditions at once.
SUMIFS extends SUMIF to several criteria — total amounts that match a category AND a date range AND a region, for instance.
Excel
=SUMIFS(C:C, A:A, "Sales", B:B, ">="&DATE(2026,1,1))Google Sheets
=SUMIFS(C:C, A:A, "Sales", B:B, ">="&DATE(2026,1,1))How it works
- 1C:C is the range to sum.
- 2A:A = "Sales" is the first condition.
- 3B:B >= 1 Jan 2026 is the second condition.