Calculation Issues

Fix Excel AutoSum Returning Zero for Text Numbers

Bushra ParveenBushra Parveen Nov 18, 2026 868 views

Question details

The user needs Excel AutoSum to total values that may be stored as text.

Fix Excel AutoSum Returning Zero for Text Numbers
Product
Microsoft Excel
Device & OS
not provided
Scenario
Adding a range of values with AutoSum.
Observed behavior
AutoSum returns zero instead of the expected total.
Before you start

Check that the AutoSum formula references the intended cells. Look for a green triangle or warning icon on the source cells, which may indicate that numbers are stored as text.

Solution 1Recommended

Convert text numbers using the Excel warning icon

Use this method when Excel identifies the source values as numbers stored as text.

1
Select the source values

Select the cells included in the AutoSum formula and look for the warning icon beside the selection.

2
Convert the values

Click the warning icon and choose Convert to Number.

3
Check the total

Select the AutoSum cell and verify that its SUM formula includes the converted range. If the result does not update, use Formulas > Calculate Now.

Convert text numbers using the Excel warning icon
No warning icon?: The icon may not appear if error checking is disabled or Excel does not flag the cells. Try the VALUE formula or Text to Columns instead.
Calculate totals in WPS Spreadsheets

Convert text numbers and calculate a total in WPS Spreadsheets

Open the workbook in WPS Spreadsheets, use VALUE to convert text numbers in a helper column, and sum the converted values.

  1. 1. Open the workbook: Open WPS Spreadsheets and choose Open to select your Excel workbook.
  2. 2. Convert the first value: In an empty cell beside the first value, enter =VALUE(A1), replacing A1 with the source cell address.
  3. 3. Fill the helper column: Drag the formula cell's fill handle down to convert the remaining values.
  4. 4. Calculate the total: In an empty cell below the converted values, enter a SUM formula such as =SUM(B1:B10), adjusting the range to match the helper column, and press Enter.
Convert text numbers before calculating an AutoSum totalOpen and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet formulas and a familiar interfaceGet started with WPS Office for free
QA img-9

Frequently Asked Questions

Why does Excel AutoSum return zero when cells contain numbers?

The values may be stored as text, which SUM ignores when it references a range. Select the source cells and use the warning icon's Convert to Number option if it appears.

How can I tell whether a number is stored as text?

Select the cell and look for a green triangle or a warning icon indicating a number stored as text. These indicators may not appear if error checking is disabled.

Can I convert text numbers without the warning icon?

Yes. Enter =VALUE(A1) in an empty helper cell and fill it down, or select the source cells and use Data > Text to Columns with the General format.

What should I check if the total still does not update?

Select the SUM formula and confirm that it references the converted cells. Then choose Formulas > Calculate Now and check the workbook's calculation settings under Formulas > Calculation Options.