Sum and calculation · Short guide

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?

  1. Select the Total cell and find the first and last cell in the formula bar.
  2. Compare with the actual range of data that needs to be summed. Check the headers, subtotals and especially the last row.
  3. 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)

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