If your Excel formula not working returns 0, this article will help you to solve the problem. Here, weâ€™ll describe 4 reasons that are responsible for this problem and the required solutions to fix those problems.

**Table of Contents**Expand

## How to Solve Problems When Excel Formula Not Working and Returns 0: 4 Methods

The following **Employee List** table shows the **ID**, **Name**, and **Salary** columns. When we calculate the **Total Salary **of the **Salary** column in cell **D11**, we see** 0** instead of the required result. Here, we will show you 4 reasons that are responsible for this problem and also we will describe solutions. Here, we used Excel 365. You can use any available Excel version.

### Method-1: Number Stored as Text Thus Formula Not Working Returns 0

In the following **D11** cell, we write the following formula using **the SUM function** to get the sum of the Salary column.

`=SUM(D5:D9)`

However, in cell** D11** we see **0** instead of getting a result. This is because the cells of the Salary column are in **Text** format, therefore, the formula does not work.

âž¤ To see that the cells of the Salary column are in **Text **format, first of all, we will select the cells of the Salary column from **D5** to **D9**.

âž¤ After that, we will go to the **Home** tab > click on the **Number** option.

We will see from the **Number Format** box that the format is set to** Text**.

Now, we want to set the Salary column cells format to** Number**.

âž¤ To do so, at first, we will select the Salary column cells from **D5** to **D9**.

We will see a yellow color sign box at the top left of the **D5** cell.

âž¤ After that, we will click on that box.

âž¤ Afterward, we will select **Convert to Number**.

Finally, we can see the **Total Salary **in cell **D11**.

### Method-2: Manual Calculation Mode is Turned On and Formula Not Working

In the following cell **D11 **when we write the following formula with the** SUM function,** we will see that the result shows as **0**.

`=SUM(D5:D9)`

Here, the **Manual** calculation mode is turned on, therefore, the result is calculated as **0**.

âž¤ To check whether the **Manual** calculation mode is turned on or not, first, we will go to the **Formulas** tab.

âž¤ After that, we will select the **Calculation Options**.

We will see the marked** Manual** option. To get the result in cell **D11**, we have to unmark the **Manual** option and we have to mark the **Automatic** option.

âž¤ Here, we unmarked the **Manual** option, and we mark the **Automatic** option.

Finally, we go back to cell **D11**, and we can see the result in cell **D11**.

**Read More: **[Fixed!] Why Is My Excel Formula Not Updating Automatically

### Method-3: Text Format in Formula Cell

In the following cell **D11**, we used the **SUM** function to get the **Total Salary** of the **Salary **column. However, the result in cell **D11** is **0**.

Here, the reason is that cell **D11** where we write the formula is formatted as **Text**.

We can check that there is a **Text** format in cell **D11**.

âž¤ First of all, we will click on cell **D11**.

âž¤ Afterward, we will go to the **Home** tab > click on the **Number** option.

We can see in the **Number Format** box that there is **Text** format in cell **D11**.

Now, we want to change the format of cell** D11** from **Text **to **Currency**.

âž¤ First of all, from the** Numbe**r option, we will click on the down arrow from the **Number Format** box, and mark that box with red color.

âž¤ After that, we will choose **Currency**.

Finally, in cell **D11** we can see the calculated sum.

### Method-4: Formula Returns 0 for Circular References

Here, we can see that the **Total Salary** in cell **D11** shows **$0**, and in the **Formula Bar**, we can see the following formula.

`=SUM(D5:D11)`

Here, the formula adds from cell **D5** to **D11**, however, **D11** is the cell where we write the formula. Hence, the cell **D11 **becomes a circular reference, Therefore, the result becomes **$0**.

We can solve the problem easily by the following procedures.

âž¤ First of all, in cell **D11**, we will write the following formula.

`=SUM(D5:D9)`

Here, the formula adds up from cell **D5** to **D9**, therefore, there is no circular reference.

âž¤ After that, press **ENTER**.

Finally, we can see the **Total Salary** in cell **D11**.

**Download Workbook**

## Conclusion

Here, we tried to show you 4 solutions when the Excel formula not working returns 0. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, feel free to contact us in the comment section.

**<< Go Back to Excel Formula Errors | Excel Formulas | Learn Excel**