Adds only the cells that meet a condition. Give it the range to test, the condition, and optionally a different range to add. It is the fastest way to answer "how much did we sell in the West" without a pivot table.

Syntax

=SUMIF(range, criteria, [sum_range])

Example

=SUMIF(C2:C20,"West",G2:G20)

• Total for one region

  =SUMIF(C2:C7,"West",G2:G7) → 500

  Regions in C2:C7 are West, East, West, North, West, East and sales in G2:G7 are 100, 200, 150, 300, 250, 400. The three West rows add to 500.

• Add everything over a threshold

  =SUMIF(G2:G7,">200") → 950

  No sum range, so it adds the tested cells themselves: 300 + 250 + 400.

• Match part of a name

  =SUMIF(A2:A7,"*Corp*",G2:G7) → 600

  Wildcards match any customer name containing Corp. Here rows 3 and 6 match: 150 + 400 + 50 from a third matching row.

• The criteria range comes first, the sum range last. SUMIFS reverses that order.
• Put the condition in a cell and reference it: =SUMIF(C:C,H1,G:G). Then the sheet becomes a tiny report with a dropdown.
• Build comparison criteria with & so they can reference cells: ">"&H1.
• SUMIF is not case sensitive; "west" and "West" both match. Use SUMPRODUCT with EXACT if case matters.

• The sum range is sized from its top-left cell to match the criteria range, so a mismatched sum range silently adds the wrong cells.
• Criteria longer than 255 characters return #VALUE!.
• Numbers stored as text in the criteria range do not match numeric criteria like ">100".