Skip to content
Excel

SUMIF function in Excel

Adds the cells specified by a given criteria

=SUMIF(range, criteria, [sum_range])

SUMIF syntax and parameters

Three arguments, two required.

  • rangerangeRequired
  • criteriaanyRequired
  • sum_rangerangeOptional

SUMIF examples

Formulas you'll actually reuse.

  1. Revenue for the West region only:

    =SUMIF(A2:A200, "West", C2:C200)

    Result52300

  2. Only the deals over $1,000 — the criterion is a string:

    =SUMIF(C2:C200, ">1000", C2:C200)

    Result121400

SUMIF in Google Sheets

Same name — your formula ports as-is.

Try SUMIF in the playground

Edit the example — nothing to install.

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

Loading the editor…

Related functions

More ways Excel gets this done.