Skip to content
Google Sheets

SUMIFS function in Google Sheets

Returns the sum of a range depending on multiple criteria.

=SUMIFS(sum_column, criteria_column1, criterion1, criteria_column2, criterion2)

SUMIFS syntax and parameters

Five arguments, five required.

  • sum_columnrangeRequired

    The data column to sum.

  • criteria_column1rangeRequired

    The data column to check against criterion1.

  • criterion1anyRequired

    The pattern or test to apply to criteria_column1.

  • criteria_column2rangeRequired

    Additional data columns to check.

  • criterion2anyRequired

    Additional criteria to check.

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 Excel

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