SUMIF adds values that meet a single condition; SUMIFS handles multiple conditions. Both are core to summarizing data without a pivot table.
Do it with AI insteadChoose the range to sum
For SUMIFS, the sum range comes first: =SUMIFS(sum_range, ...).
Add criteria pairs
Add each criteria_range and its criterion, e.g. region column = "West".
Combine conditions
List more pairs to require all conditions, e.g. region AND month.
=SUMIFS(Sales, Region, "West", Month, "Q3")SUMIF takes one condition (criteria first); SUMIFS takes many (sum range first). Use SUMIFS when in doubt.