Skip to content
Excel

SUMIFS function in Excel

Adds the cells in a range that meet multiple criteria

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

SUMIFS syntax and parameters

Five arguments, three required.

  • sum_rangerangeRequired

    The range of cells to sum.

  • criteria_range1rangeRequired

    The range that is tested using Criteria1.Criteria_range1 and Criteria1 set up a search pair whereby a range is searched for specific criteria. Once items in the range are found, their corresponding values in Sum_range are added.

  • criteria1anyRequired

    The criteria that defines which cells in Criteria_range1 will be added. For example, criteria can be entered as 32, ">32", B4, "apples", or "32".

  • criteria_range2rangeOptional
  • criteria2anyRepeating

SUMIFS examples

Formulas you'll actually reuse.

  1. West revenue since July 1 — every condition must hold:

    =SUMIFS(C2:C200, A2:A200, "West", D2:D200, ">=" & DATE(2026, 7, 1))

    Result18750

  2. A wildcard match on the rep's name AND an amount cap:

    =SUMIFS(C2:C200, B2:B200, "Maria*", C2:C200, "<5000")

    Result9600

SUMIFS in Google Sheets

Same name — your formula ports as-is.

Try SUMIFS in the playground

Edit the example — nothing to install.

Preloaded with the SUMIFS formula from Example 1 — change anything and watch it respond.

Loading the editor…

SUMIFS errors

What they mean — and the fixes.

  • #VALUE!

    A criteria range is a different size from the sum range — every range must span the same rows.

Related functions

More ways Excel gets this done.