When you need to add up numbers that meet more than one condition at the same time, the SUMIFS function in Google Sheets is the tool you reach for. Think totals filtered by region and product, by a date range, or by a few rules stacked together.
This article walks through five practical examples, from a simple two-condition sum to date ranges and skipping blank cells. Each one uses a small dataset you can copy and try yourself.
SUMIFS Function Syntax in Google Sheets
Here is how the function is put together.
=SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])
- sum_range is the range of numbers you want to add up.
- criteria_range1 is the first range you test against a condition.
- criterion1 is the condition applied to that first range.
- criteria_range2, criterion2 are optional extra range and condition pairs. You can keep adding them.
Every criteria range has to be the same size as the sum range, otherwise you get an error.
When to Use SUMIFS Function
- Totaling sales for a specific region and product at once.
- Adding amounts that fall between a lower and an upper limit.
- Summing revenue booked inside a date range.
- Filtering on three or more rules, like region plus rep plus product.
- Ignoring rows where a key column is blank.
Example 1: Sum With Two Conditions
Let’s start with the core pattern, two conditions at the same time.
Below is the dataset with Region in column A, Product in column B, and Sales in column C, across rows 2 to 6.
I want the total sales where the region is East and the product is Widget.
Here is the formula:
=SUMIFS(C2:C6, A2:A6, "East", B2:B6, "Widget")
The formula adds only the rows where both tests pass. Two rows are East Widget, 100 and 120, so the result is 220.
Notice the sum range comes first, then each range and condition pair follows.
Pro Tip: The sum_range comes FIRST in SUMIFS, which is the opposite of SUMIF where the sum range comes last. If you are switching between the two, that flipped order trips up a lot of people.
Example 2: Sum Numbers Inside a Range
You can point more than one condition at the same column, which is handy for ranges.
Below is the dataset with an Order label in column A and an Amount in column B, across rows 2 to 6.
I want to total only the amounts between 100 and 250, inclusive.
Here is the formula:
=SUMIFS(B2:B6, B2:B6, ">=100", B2:B6, "<=250")
Both conditions look at column B. The first keeps amounts of at least 100, the second keeps amounts of at most 250.
Only the 150 and 220 orders clear both tests, so the result is 370.
Example 3: Sum Within a Date Range
Dates are just numbers under the hood, so the same range trick works on them.
Below is the dataset with a Date in column A and Revenue in column B, across rows 2 to 6. The dates span January through March.
I want the total revenue booked in January only.
Here is the formula:
=SUMIFS(B2:B6, A2:A6, ">="&DATE(2026,1,1), A2:A6, "<="&DATE(2026,1,31))
How this formula works:
DATE(2026,1,1)builds the start date andDATE(2026,1,31)builds the end date.- The
&joins each comparison operator to its date so the condition reads as a single text string. - Only rows with a date on or after Jan 1 and on or before Jan 31 are added.
Three January rows qualify, 500 plus 400 plus 350, so the result is 1250.
Pro Tip: Always build dates with the DATE function rather than typing “2026-01-01” as text. A typed date string can be read differently depending on your locale, while DATE is unambiguous every time.
Example 4: Sum With Three Conditions
SUMIFS does not stop at two rules. You can chain as many criteria pairs as you need.
Below is the dataset with Region in column A, Rep in column B, Product in column C, and Sales in column D, across rows 2 to 6.
I want sales where the region is East, the rep is Alice, and the product is Widget.
Here is the formula:
=SUMIFS(D2:D6, A2:A6, "East", B2:B6, "Alice", C2:C6, "Widget")
How this formula works:
- The sum range is column D, the Sales column.
- Three range and condition pairs follow, one for region, one for rep, one for product.
- A row is only added when all three conditions are true at once.
Two rows match East, Alice, and Widget, 100 and 120, so the result is 220.
Pro Tip: The order of the criteria pairs does not matter. Region first or product first gives the same total, so arrange them in whatever order reads most naturally to you.
Example 5: Skip Blank Cells in a Criteria Column
Sometimes you only want rows where a column actually has something filled in.
Below is the dataset with Region in column A, Channel in column B, and Sales in column C, across rows 2 to 6. One channel cell is empty.
I want total East sales, but only where the channel is not blank.
Here is the formula:
=SUMIFS(C2:C6, A2:A6, "East", B2:B6, "<>")
The "<>" operator means not equal to blank. So a row counts only when the region is East and the channel cell has a value.
The East rows with a channel are 300, 250, and 100. The blank-channel East row is left out, so the result is 650.
Tips & Common Mistakes
- Keep every range the same size. If your sum range is C2:C6, each criteria range must also span five rows. Mismatched sizes throw an error.
- Wrap operators in quotes. Conditions like “>=100” or “<>” go inside quotes. For a comparison against a date or a cell, join the operator with
&, as in “>=”&DATE(2026,1,1). - Watch the argument order versus SUMIF. In SUMIFS the sum range comes first. In SUMIF it comes last. Mixing them up is the most common slip.
SUMIFS handles the everyday “add this up, but only when these conditions are met” job without any helper columns. Once the multi-condition pattern clicks, date ranges and three-rule filters feel like the same move.
Try the formulas on your own data and adjust the conditions to fit.
List of All Google Sheets Functions
Related Google Sheets Functions / Articles: