SUMIFS Function in Excel
Learn how to use the SUMIFS function in Excel, understand the syntax and common use cases, and let ExcelGPT adapt the formula to your real workbook structure.
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)sum_rangeRequiredThe cells to total.
criteria_range1RequiredThe first range to test.
criteria1RequiredThe first condition to apply.
criteria_range2+OptionalAdditional ranges and criteria pairs.
Examples
=SUMIFS(F:F, B:B, "West", C:C, "Closed Won")Totals revenue only where region is West and status is Closed Won.
=SUMIFS(E:E, A:A, ">="&DATE(2026,1,1), A:A, "<="&DATE(2026,3,31))Totals values in column E for rows with dates in Q1 2026.
Common mistakes
Check the argument order, data types, and references used in SUMIFS.
Review whether ranges, blank cells, error values, or dynamic results are affecting the formula.
Validate the formula on a few sample rows before scaling it across the workbook.
Related functions
Need a variant of this formula?
Describe your workbook structure and ExcelGPT can generate a version tailored to your real columns, ranges, and edge cases.