Why does the Excel total formula skip a row?
Braxorn · Last updated 2026-11-22 · English
If the total is less than you expected, first look at the range covered by the formula. The new row added to the end of the list may be outside the current total range. Even if Excel produces a valid result, that result may be incomplete from a business perspective.
What can you do?
- Select the Total cell and find the first and last cell in the formula bar.
- Compare with the actual range of data that needs to be summed. Check the headers, subtotals and especially the last row.
- Correct the range if the missing row is actually included in the total. Compare the result to an independent checksum. Cells
A small example
B2:B8 are 10 each, and B9 is 25. =SUM(B2:B8) in B10 results in 70; If B9 is to be included, the result of =SUM(B2:B9) should be 95.
What to watch for
Do not blindly increase the range. The line for the return, subtotal, or individual period may have been intentionally excluded. Including the total cell in its own range can create a circular reference.
Check the result
Add a new test row and verify that the total changes by the expected amount.
Examples are synthetic. Formulas use English function names and comma separators; names or separators may differ with your Excel language and regional settings. Menus and features vary by version.
Microsoft source (English)
Review your own workbook
You can start reviewing your Excel file in Braxorn. Check which controls are supported and review incomplete checks alongside the report scope.
Review your file