Conditional formula page

SUMIF Formula With One Condition

Use SUMIF when one criteria range controls which numeric values should be added.

Best for

Total values by one condition with SUMIF.

What it returns

With the sample data, this totals Amount values for East rows.

Copy formulas

Excel formula

=SUMIF(B2:B100, "East", D2:D100)

Google Sheets formula

=SUMIF(B2:B100, "East", D2:D100)

Excel / Google Sheets difference

Excel and Google Sheets use SUMIF for one condition. The criteria range and sum range must refer to corresponding rows.

Date	Region	Product	Amount	Rep
2026-01-04	East	Widget	420	Maya
2026-01-12	West	Widget	310	Noah
2026-02-03	East	Gadget	275	Maya
2026-02-15	East	Widget	640	Iris

What it returns

With the sample data, this totals Amount values for East rows.

Syntax piece	Role in the formula
B2:B100	The Region criteria range.
"East"	The criterion selecting rows whose Region is East.
D2:D100	The Amount range whose matching numeric values are added.

Total East amounts

=SUMIF(B2:B100, "East", D2:D100)

Excel: Use the sample sales table with East amounts totaling 1335 in D2:D100. Returns: 1335

Select West from a cell

=SUMIF(B2:B100,F2,D2:D100)

Google Sheets: Enter West in F2; matching amounts total 310. Returns: 310

Sum amounts greater than 300

=SUMIF(D2:D100, ">300", D2:D100)

Excel: Use D2:D100 as both the criteria and sum range; qualifying amounts total 1370. Returns: 1370

Issue	Likely cause	Fix
SUMIF adds the wrong rows	The criteria and sum ranges start or end on different rows.	Align both ranges to the same records, such as B2:B100 and D2:D100.
Matching rows produce zero	The Amount values are stored as text rather than numbers.	Convert the Amount column to numeric values before using SUMIF.
A cell-based numeric criterion is ignored	Comparison operators need quotes and concatenation when the threshold comes from a cell.	Use a form such as ">"&F2 rather than typing the operator outside the quoted criterion.

Do not use SUMIF when several conditions must be true on each row; use SUMIFS instead.

Alternative	When to use it
SUMIFS Formula	Use when the total must satisfy two or more conditions.
SUMIFS Formula Builder	Use when criteria pairs and aligned ranges need to be configured interactively.

How many conditions does SUMIF support?

SUMIF supports one condition. Use SUMIFS when multiple criteria ranges must be evaluated together.

Why must the criteria and sum ranges align?

SUMIF evaluates each criteria row and adds the value from the corresponding sum row, so the ranges need matching boundaries.