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.

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

Step 3: In the dialog, select Formulas.

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

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.

Step 1: Open the Formulas tab.

Step 2: In Formula Auditing, click Error Checking.

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.

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.

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.
Use licensed Office to get official updates and fixes
- Office Home 2024 – Word, Excel, PowerPoint, 1 PC, perpetual · VND 2,950,000
- Office Home & Business 2024 – adds Outlook, licensed for business, 1 PC · VND 5,500,000
- Microsoft 365 Business Standard – always-updated Office + email + OneDrive, per user · VND 3,550,000/user/year
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.




