Excel SUMIF: Add Values with One Condition

No. SUMIF treats Paid and paid as the same text.

By Szabó Gergő · Updated Aug 31, 2026

SUMIF adds values that meet one condition. The condition can target text, a number, a date, a comparison, or a wildcard pattern.

Syntax and arguments

=SUMIF(range, criteria, [sum_range])

range: Cells Excel checks against the condition.
criteria: The condition, such as "Paid", ">=100", or a cell reference.
sum_range: Optional cells to add; if omitted, Excel adds matching cells in range.

Sum paid invoices

Statuses are in A2:A200 and invoice values are in D2:D200.

=SUMIF(A2:A200,"Paid",D2:D200)

Only values in D whose corresponding status is Paid are added.

Use a criterion from a cell

Regions are in B, revenue is in E, and H2 contains the selected region.

=SUMIF(B2:B500,H2,E2:E500)

Changing H2 updates the regional total without editing the formula.

Match text that contains a word

Descriptions are in A and amounts are in C.

=SUMIF(A2:A100,"*subscription*",C2:C100)

Asterisks match any characters before or after subscription.

Criteria and sum ranges do not align
Start both ranges on the same row and give them the same dimensions.
Comparison operator is not quoted
Write numeric criteria as strings, such as ">=100".
Trying to apply multiple conditions
Use SUMIFS when more than one range must satisfy criteria.

SUMIF handles one condition. SUMIFS handles multiple conditions and places sum_range first.

Yes. Join the operator and cell reference, for example "<="&F2.

No. SUMIF treats Paid and paid as the same text.