Fixing the zero sum function error in Excel

Buzz

Ngày cập nhật gần nhất: 15/4/2026

The zero sum function error is a common mistake encountered by many Excel users during calculations. Lengthy spreadsheets can make it difficult to detect errors. In this article, Mytour will provide quick solutions to address this issue.

Excel is widely known as an office tool used for computing complex spreadsheets. Currently, Excel 2013 is considered the most popular software for learning Excel, benefiting students in their studies. The 2013 version of Excel optimally supports users in computational formulas.

In Excel, calculations are primarily done using formulas to save time. However, errors often occur due to inaccurate formula entries, leading to incorrect results. One notable error is the zero sum function error. Although the sum function is widely used for calculating totals in Excel, a result of 0 usually indicates incorrect input. Mytour will now guide readers on rectifying the sum function error resulting in 0.

Note: This article is performed on Excel 2013 version. However, for other versions like Excel 2016, 2010, 2007, or 2003, you can also perform similar actions.

Guide to fixing the zero sum function.

Most novice Excel users often encounter this error, also known as Circular Reference, inadvertently causing endless loops, making Excel unable to process and returning a value of 0. We can visualize this error through the following example.

Step 1: Open the Excel file needing to fix the SUM function error resulting in 0, then click on File.

Step 2: Here, locate and click on the Options option.

Step 3: In Excel Options, select the Formulas section and check the Automatic mode under Calculation Options, then press OK.

Here is the method to fix the SUM function error in Excel when it fails to sum up data. After activating the automatic calculation mode, apart from the SUM function, other functions will also execute commands automatically in Excel. Additionally, some users often encounter the sum function error returning 0 when entering incorrect data or selecting the wrong row when entering commands. To resolve this, readers can follow these steps:

Step 1: We have an Excel table consisting of 9 numbers with 9 different values. The task is to calculate the sum of these 9 numbers, but as shown in the image, we see the result is 0.

In the table, there are 9 values belonging to Column C with the order from C10 to C18, however, in the formula, it references up to C19. Consequently, we unintentionally created a circular reference, an endless loop because it refers back to itself.

Specifically, we understand C19 (total) = C10+C11+…+C18+C19 (itself), inadvertently creating a loop.

Excel will not be able to compute this formula and will return a value of 0.

Step 3: To fix this error, we remove the value in column C19, leaving =SUM(C10:C18) then Enter to display the result again.

Frequently Asked Questions

What common mistake leads to a zero sum function error in Excel?

The zero sum function error in Excel often arises from inaccurate formula entries, such as referencing incorrect cell ranges or creating circular references that prevent Excel from processing calculations correctly.

How can users quickly resolve the zero sum function error?

To resolve the zero sum function error, ensure that automatic calculation mode is enabled in the Formulas section under Excel Options. Additionally, check for circular references and correct any incorrect cell references in your formulas.

What steps should be taken to fix a SUM function that returns 0?

To fix a SUM function returning 0, first, check for circular references by reviewing your formula. For example, if your formula refers to the cell itself, remove that reference. Update the formula to accurately reflect the range, such as =SUM(C10:C18).

Is the zero sum function error specific to Excel 2013 or applicable to other versions?

No, the zero sum function error is not specific to Excel 2013. Users of other versions, including Excel 2003, 2007, 2010, and 2016, can also encounter this error and apply similar steps to resolve it effectively.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]