How to Use SUMIFS in Google Sheets

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Intermediate · 7 min read · includes 2 free exercises

In short: SUMIFS adds up the values in one range where every condition you give is met. The formula is =SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...]).

What SUMIFS does

SUMIF handles one condition. SUMIFS handles one or more. You use it for questions such as "how much did we sell in the East region and of the product Pen?" A row is added only if it passes every test.

SUMIFS syntax

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

Note the order: the range to add comes first. In SUMIF it comes last. Google's help page also says that returning a sum across multiple columns is not supported, so sum_range should be a single column or row. Keep every range the same size.

A step-by-step example

Here is a small sales table in cells A1:C7.

ABC
1RegionProductAmount
2EastPen120
3WestPen90
4EastBook200
5EastPen60
6WestBook150
7EastBook80

To total the sales in the East region for the product Pen:

=SUMIFS(C2:C7, A2:A7, "East", B2:B7, "Pen")

This returns 180. Here is why:

  1. Sheets finds the rows where column A is East: rows 2, 4, 5 and 7.
  2. Of those, it keeps the rows where column B is Pen: rows 2 and 5.
  3. It adds the amounts in those rows: 120 + 60 = 180.

Mix text and number conditions

Each pair can use a different kind of test. To total East sales that are larger than 100:

=SUMIFS(C2:C7, A2:A7, "East", C2:C7, ">100")

This returns 320 (120 + 200). The same column can appear as both the sum range and a criteria range. To use a cell value in a test, join it with an ampersand, as in ">"&F1.

Common SUMIFS mistakes

Try it yourself

Use the sales table above (A1:C7). Type your formula into the box, starting with =, then press Check.

Exercise 1: Two conditions

Write a formula that totals the Amount (column C) for rows where the Region is East and the Product is Pen.

Hint: start with the sum range C2:C7, then add two range-and-criterion pairs.

Exercise 2: Text plus a number

Write a formula that totals the Amount for East rows where the Amount is greater than 100.

Hint: column C is both the sum range and the second criteria range.

What to learn next

Syntax and rules in this guide were checked against Google's SUMIFS help page. See all guides.