Why SUMIF Is Not Working in Excel

SUMIF usually breaks in quiet ways. It may return zero, miss rows that should match, or total the wrong values without showing an error. The formula syntax is simple, so the problem is often in the ranges, criteria, or source data.

Start by checking whether the condition range, criteria, and sum range line up exactly with the rows you expect to include.

Check the SUMIF syntax

SUMIF uses this structure:

For example, to sum campaign spend for rows where column A equals Paid Search:

The first range is where Excel checks the condition. The final range is what Excel adds. If those ranges point to different row sets, the total can be wrong.

Match the range sizes

The criteria range and sum range should have the same shape. This is risky:

Excel may still return a result, but it is easy to misalign the rows. Use matching ranges:

In expense trackers and marketing spend sheets, this usually happens after new rows are added to one table but not the related summary formula.

Check text criteria

Text criteria need quotes unless they come from another cell:

or:

If SUMIF returns zero, compare the criteria text to the source data. Hidden spaces, inconsistent capitalization, punctuation, or slightly different category names can cause misses.

SUMIF text criteria are case-insensitive, so capitalization alone does not cause a mismatch. Focus first on spaces, punctuation, non-printing characters, and values stored as the wrong type.

Use TRIM to clean ordinary spaces:

Check number and date criteria

Comparison criteria need quotes:

If the comparison value comes from a cell, join the operator to the reference:

For dates, avoid typing ambiguous date text directly into the formula. Put the date in a cell and reference it, or use DATE:

Upgrade to SUMIFS when there is more than one condition

SUMIF handles one condition. If the total needs category plus month, owner plus status, or region plus product, use SUMIFS:

Remember that SUMIFS puts the sum range first, while SUMIF puts it last.

Common causes and fixes

Do this with AI

SUMIF debugging gets slow when categories, dates, and ranges have drifted across a working sheet. The hard part is proving which rows should have matched.

"Fix the SUMIF totals in this marketing spend tracker and show me which category names or ranges were misaligned"

Griddy can inspect the formula ranges, clean source categories, and rewrite the totals so the summary matches the underlying rows.

Related guides: SUMIFS in Excel and convert text to numbers.

Sources

• Microsoft Support: SUMIF function
• Microsoft Support: Sum values based on multiple conditions