Fix Excel SUM Returning 0 (Formula Not Calculating)

Hào Võ · Updated Nov 18, 2026

Sửa lỗi tính tổng hàm SUM bằng 0 trong Excel 100% thành công

Quick answer: If SUM in Excel returns 0 or does not update, the two usual causes are (1) calculation set to Manual – switch it to Automatic under File > Options > Formulas – and (2) a circular reference – find it with Formulas > Error Checking > Circular References and fix the formula. The steps below work in Excel 2007–2019, Microsoft 365 and Excel for Mac.

What does the “SUM equals 0” problem look like?

It is one of the most common Excel problems, and it has more than one cause. Sometimes the formula shows the right result when you press Enter, but when you drag it down to other cells the result does not change. In other cases the formula shows 0 even though the numbers clearly add up – for example 7 + 5 gives 0 instead of 12. Do not delete your data or formulas; the fixes below are quick.

Two ways to fix SUM returning 0 in Excel

1. SUM does not update when you copy the formula

If the formula is correct in the first cell but copied cells keep the old result, automatic calculation is turned off. Turn it back on:

Step 1: Open the Excel file and click File.

Fix Excel SUM returning 0 - step 02

Step 2: Click More > Options (or Options directly if it is visible).

Fix Excel SUM returning 0 - step 03

Step 3: In the dialog, select Formulas.

Fix Excel SUM returning 0 - step 04

Step 4: Under Calculation options, clear Manual, select Automatic and click OK.

Fix Excel SUM returning 0 - step 05

2. SUM returns 0 when you enter data (circular reference)

This happens when a formula refers back to its own cell directly or indirectly, creating a calculation loop.

Fix Excel SUM returning 0 - step 06

Step 1: Open the Formulas tab.

Fix Excel SUM returning 0 - step 07

Step 2: In Formula Auditing, click Error Checking.

Fix Excel SUM returning 0 - step 08

Step 3: In the drop-down, choose Circular References. Excel shows the cell causing the loop (F3 in the example); click it to jump to that cell.

Fix Excel SUM returning 0 - step 09

Step 4: Remove or move the formula, or correct its references so it no longer includes its own cell. The SUM result will then calculate correctly.

Fix Excel SUM returning 0 - step 10

Video guide (Vietnamese): fix Excel SUM returning 0.

Other things to check

  • Numbers stored as text: cells with a green triangle or left-aligned numbers are text; convert them with Convert to Number or Data > Text to Columns.
  • Hidden spaces or non-breaking spaces copied from other systems: clean them with TRIM/SUBSTITUTE.
  • The range in the formula does not include the cells you expect.

Conclusion

A SUM that returns 0 is easy to fix once you know the cause: switch calculation to Automatic, remove circular references and make sure values are real numbers. If your team keeps running into Excel or Office issues, IT Systems’ IT Helpdesk can help.

Need help with this in your office?

IT Systems Vietnam supports businesses remotely within 30 minutes and on site in Ho Chi Minh City and Hanoi.

Contact IT Systems On-site computer repair

Use licensed Office to get official updates and fixes

Not sure which to pick? See Office 2024 vs Microsoft 365. Prices excl. VAT, from IT Systems Store, Nov 2026.

FAQ

Why does SUM return 0 even though there are numbers?

Usually the cells store numbers as text, values pasted from other software contain spaces or hidden characters, or Excel is set to manual calculation.

How do I know a cell stores a number as text?

The number is left-aligned, a green triangle shows in the corner, or ISTEXT returns TRUE. Convert in bulk with Convert to Number or Data > Text to Columns.

I changed the format to Number but SUM is still 0. Why?

Changing the format does not convert existing values. Re-enter them, use Text to Columns or multiply the range by 1 with Paste Special, then press F9 to recalculate.

Request adviceChat on ZaloCall hotline