SUMIFS

Adds up values that meet several conditions at once.

Syntax

SUMIFS(sum_range, criteria_range1, criteria1, ...)

Math Functions.

Practise SUMIFS4 interactive exercises, free, no account needed

Need the formula for your own sheet? Use the SUMIFS Formula Generator

=SUMIFS(B2:B9,C2:C9,"East",D2:D9,"Oct")

Returns 9,325

Totals October orders from the East region only.

SUMIFS reverses SUMIF's argument order — the sum range comes FIRST. Getting this backwards is the single most common mistake with it.

Each of these is a wrong turn the practice exercises recognise and name. They are the misconceptions, not the answers.

SUMIF handles one condition, so this totals every East order including September. The task has two conditions — region and month — which is what SUMIFS is for.Total sales for a region and month with SUMIFS
Right answer in this one cell, and wrong everywhere else. Fill it down and the data ranges slide down with it; fill it across and they slide sideways. The data has to be locked while the two labels stay free to move.Fill a two-way summary with SUMIFS
This is the formula as you found it. SUMIFS wants the range it is adding up first, then range-and-criteria pairs after it — the opposite way round from SUMIF, which puts the sum range last.Fix a SUMIFS with its arguments swapped
Your second criteria range is one row shorter than the others. Every range in SUMIFS must cover the same rows or the comparison silently misaligns.Total sales for a region and month with SUMIFS

Knowing what a function does and being able to write it from memory are different skills. These close the gap.