Function reference /Math & aggregation

SUMIFS

Run in a real sheet

Adds up numbers that meet several conditions at once.

SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])

SUMIFS is SUMIF with more than one test — sales in the West, in Q3, above 1000. Conditions combine with AND.

Executed 23 Aug 2026 Google Sheets · unedited screenshot
=SUMIFS(C2:C6, A2:A6, "West", C2:C6, ">1000") running in Google Sheets, returning 2700
The formula sits in the formula bar and its answer sits in the grid, in one frame. West rows with sales above 1000 — both of Ana's and Cara's figures qualify.

Worked example

RegionRepSales
WestAna1200
EastBen900
WestCara1500
NorthDan600
EastEve1100
 
=SUMIFS(C2:C6, A2:A6, "West", C2:C6, ">1000")

Returns 2700.

Arguments

ArgumentRequiredWhat it does
sum_range Yes The numbers to add. Comes first, unlike SUMIF.
criteria_range1 Yes The range the first condition tests.
criterion1 Yes The first condition.

Gotchas

  • 01The sum range comes FIRST here and LAST in SUMIF. Swapping them is the most common cause of a zero total.
  • 02All ranges must be the same height.
  • 03Conditions are AND only. There is no OR — use two SUMIFS added together, or QUERY.