Quick answer
SUMIFS not working: How to Fix It usually happens because the formula, source data, formatting, or calculation settings do not match what the workbook needs. Start by testing the issue on one simple row before changing the whole file.
What it usually means
The workbook is giving you a warning sign. The fastest fix is to separate the problem into four checks: formula syntax, referenced cells, data type, and workbook settings.
Likely causes
- The selected range, formula references, or source data may not match the intended calculation.
- Formatting can make correct values look wrong.
- Hidden rows, filters, blanks, or text values may be changing the result.
Step-by-step fix
- Reproduce the issue on a small copy of the data.
- Check the formula references one by one.
- Look for blanks, text numbers, filters, and hidden rows.
- Recalculate or refresh the related pivot table, chart, or report.
Useful check formula
=IFERROR(A2/B2,0)How to prevent it next time
- Use Excel Tables so ranges expand consistently.
- Keep helper columns visible while testing a new formula.
- Document important assumptions directly in the workbook.
- Use IFERROR only after you understand the real cause of the error.