Sum Values That Meet Multiple Conditions

Excel & Google Sheets

How it works

SUMIFS adds up values from C2:C20, but only for rows where column A equals Sales and column B is greater than 100. Note the argument order: the range to sum comes first, then the condition pairs. This is the reverse of the older SUMIF, which puts the sum range last — a regular source of confusion.

C2:C20

The values to add up. This range comes first in SUMIFS.

A2:A20,"Sales"

Condition 1: column A must equal Sales.

B2:B20,">100"

Condition 2: column B must be greater than 100. Operators go in quotes.

When to use it

Use SUMIFS for any conditional total: revenue by rep, expenses by month, quantities by warehouse. For a full breakdown by every category at once, a pivot table is usually better.

Common mistakes

• ✕Putting the sum range last, like SUMIF.

  ✓SUMIFS takes the sum range first. Mixing up the order sums the wrong column or errors out.

• ✕Summing a range that contains text.

  ✓Text cells are silently treated as zero. Check the sum column holds real numbers, not numbers stored as text.