Skip to content
Google Sheets

SUMIF function in Google Sheets

Returns a conditional sum across a range.

=SUMIF(criteria_column, criterion, sum_column)

SUMIF syntax and parameters

Three arguments, three required.

  • criteria_columnrangeRequired

    The data column which is tested against criterion.

  • criterionanyRequired

    The pattern or test to apply to criteria_column.

  • sum_columnrangeRequired

    The data column to be summed, if different from `criteria_column`.

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 Excel

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 Google Sheets gets this done.