Google Sheets SUMIF with Multiple Criteria

SUMIF is great for summing by a single condition. The moment you need two conditions — sum sales for Region = "West" and Product = "Widget" — you need SUMIFS.

SUMIFS syntax

Unlike SUMIF, SUMIFS puts the sum_range first, then alternates between criteria ranges and their conditions. You can add as many criteria pairs as you need.

Basic example

Sum all sales where the region is "West" and the product is "Widget":

• C2:C100 — the column you're summing (Sales)
• A2:A100 — first criteria column (Region)
• "West" — first criteria value
• B2:B100 — second criteria column (Product)
• "Widget" — second criteria value

All ranges must be the same size.

Using comparison operators

Criteria can include comparison operators as text strings:

This sums sales in the West region where the order value is greater than 1000.

To use a cell reference with a comparison operator, concatenate:

Summing by date range

To sum values between two dates, use two criteria on the same date column:

This sums West region sales in Q1 2026.

When to use SUMPRODUCT instead

SUMPRODUCT is more flexible than SUMIFS — it can handle OR logic and more complex array operations:

Each condition in parentheses evaluates to an array of 1s and 0s. Multiplying them together creates an AND: only rows where both are 1 contribute to the sum.

For OR logic — sum where Region is West or Product is Widget:

The >0 converts the OR result back to a binary array.

The Griddy way

SUMIFS and SUMPRODUCT get tricky fast once you're dealing with date ranges, partial text matches, or OR conditions. Describe the calculation you need:

"Sum revenue from the West and South regions for orders placed in Q1 where the product category is Hardware"

Griddy writes the correct formula for your exact columns and data structure — no guessing at syntax or debugging #VALUE! errors.