Fix the Excel 3D SUM Formula #NAME? Error in WPS Spreadsheets
Question details
The user needs to fix a #NAME? error returned by the Excel 3D SUM formula =SUM('0801:0831'!D11) when summing cell D11 across a range of worksheets.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is totaling cell D11 across worksheets from 0801 to 0831 using a 3D SUM reference.
- Observed behavior
- The formula returns #NAME? because the workbook may not contain sheets named exactly 0801 and 0831, or the sheet reference is invalid.
Open the workbook in WPS Office Spreadsheets and inspect the sheet tabs at the bottom. Verify that sheets named 0801 and 0831 exist exactly, because hidden spaces or renamed tabs will prevent the 3D reference from resolving.
Fix #NAME? by verifying sheet names and re-entering the 3D SUM formula
Use this solution when =SUM('0801:0831'!D11) returns #NAME? because sheet references are missing, misspelled, or contain hidden spaces.
A #NAME? error in a 3D SUM formula usually means the quoted sheet range cannot be resolved. The fix is to make the workbook sheet names match the formula exactly and re-enter the reference if necessary.
In WPS Spreadsheets, look at the sheet tabs along the bottom of the workbook. Confirm there are sheets named exactly 0801 and 0831, with no spaces or spelling changes.
If a sheet name is wrong, double-click its tab, type the exact name 0801 or 0831, and press Enter. Repeat for the other boundary sheet if needed.
Click the cell that contains the #NAME? error or the cell where you want the total.
Type =SUM('0801:0831'!D11) exactly and press Enter. The formula sums cell D11 across all sheets between 0801 and 0831 in tab order.
Check that the cell now shows the expected numeric total instead of #NAME?.
Build the 3D reference with the mouse to avoid typing mistakes
Use this alternative if you have already renamed the sheets but still get #NAME? and want WPS Spreadsheets to create the reference automatically.
Fix Excel 3D SUM #NAME? Errors in WPS Spreadsheets
WPS Office Spreadsheets directly resolves this Excel 3D SUM #NAME? error by helping you verify the 0801 and 0831 sheet names, re-enter =SUM('0801:0831'!D11), and recalculate the worksheet range total without converting the file.
- 1. Open the workbook in WPS Office: Launch WPS Office, open the Excel workbook that contains the #NAME? error, and enable editing if prompted.
- 2. Verify the 0801 and 0831 sheet tabs: Click through the sheet tabs at the bottom to make sure both worksheets exist with exact names and are in the correct tab order.
- 3. Enter the 3D SUM formula: Select the target cell, type =SUM('0801:0831'!D11), and press Enter to sum D11 across all worksheets from 0801 to 0831.
- 4. Replace the formula if it still fails: If the error persists, delete the old formula and re-enter it using the sheet tab method: type =SUM(, click 0801, hold Shift, click 0831, click D11, then press Enter.
Frequently Asked Questions
Why does my 3D SUM formula return #NAME? if the sheet names look correct?
In WPS Spreadsheets, a #NAME? error usually means the quoted sheet reference cannot be resolved. Check for hidden leading or trailing spaces, rename the sheets to exactly 0801 and 0831, and make sure the formula uses straight apostrophes around the sheet range.
Does =SUM('0801:0831'!D11) add every sheet between 0801 and 0831?
Yes. Excel and WPS Spreadsheets include all worksheets between 0801 and 0831 according to the workbook tab order, including the boundary sheets, and sum cell D11 from each.
How can I insert the 3D reference without typing the sheet names?
Type =SUM( in the target cell, click the 0801 sheet tab, hold Shift, click the 0831 sheet tab, then click cell D11 and press Enter. WPS Spreadsheets builds the reference for you.
What should I do if the formula still shows #NAME? after renaming sheets?
Delete the old formula, select the cell again, and re-enter it from scratch. Avoid copying curly quotes from a webpage; type the apostrophes directly in the formula bar.
