XXLFormula AI

Excel

SUMIFS Function in Excel

SUMIFS adds the cells in a range that meet multiple criteria. It is the go-to function for conditional aggregation across one or more columns.

Syntax

=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Parameters

  • sum_rangeRequired

    Cells to sum.

  • criteria_range1Required

    First range to evaluate.

  • criteria1Required

    First condition applied to criteria_range1.

  • criteria_range2, criteria2, ...Optional

    Additional range/criteria pairs (up to 127).

Examples

Sum by region and month

=SUMIFS(C2:C100, A2:A100, "West", B2:B100, ">="&DATE(2026,1,1))

Sums column C where region is West AND date is on/after 2026-01-01.

Common Errors

  • #VALUE!

    Cause: sum_range and a criteria_range have different sizes.

    Fix: Make every range the same length — SUMIFS aligns by position.

Best Practices

  • Use whole columns (A:A) sparingly; prefer Excel tables for performance.
  • Reference criteria from cells instead of hard-coding — easier to audit.

Frequently Asked Questions

Need a custom version of this formula?

Describe what you need in plain English and get a ready-to-use formula in seconds.

Generate this formula with XLFormula AI