What the Hash Symbol Means in Excel SUM Formulas and Spill Ranges
Question details
The user wants to understand the meaning of the hash symbol (#) in an Excel SUM formula such as =SUM(B29#).

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user is summing results that may come from a dynamic-array formula beginning in cell B29.
- Observed behavior
- The # symbol references the complete spilled result returned from the formula anchor cell, and a blocked output area can produce a #SPILL! error.
Check whether cell B29 contains a dynamic-array formula and identify the cells currently filled by its results. If you need to total a predefined set of cells instead, determine the exact first and last cell for the fixed range.
Use the # operator to sum a dynamic spilled range
Use this method when B29 is the anchor cell for a dynamic-array formula and you want the SUM to update automatically as the returned results change.
In =SUM(B29#), the # character is the spilled-range operator. It refers only to the complete dynamic-array output that starts in B29; it does not mean every cell below B29 until a blank cell is reached.
Select cell B29 and check the formula bar. B29 should contain the dynamic-array formula that produces multiple results.
Select the cell where you want the total, type =SUM(B29#), and press Enter.
Edit the formula in the anchor cell B29 rather than an individual cell in the spilled output, because the returned cells are controlled by the anchor formula.
If Excel displays #SPILL!, select the error cell and review the indicated spill range. Clear or move any value, merged cell, or other obstruction in the required output area.

Use a fixed cell range when the total should not depend on a spill formula
Use this method when you always want to sum the same cells, regardless of whether B29 contains a dynamic-array formula.
Sum Dynamic or Fixed Ranges Easily in WPS Spreadsheets
WPS Spreadsheets lets you build and review SUM formulas in a familiar worksheet interface. Use a fixed reference when you know the exact cells to total, then inspect formulas and source values directly in the formula bar.
- 1. Open the worksheet in WPS Spreadsheets: Launch WPS Office, choose Spreadsheets, and open the Excel workbook containing the values to total.
- 2. Select the destination cell: Click the empty cell where you want the total to appear.
- 3. Enter the SUM formula: Type =SUM(B29:B49) in the formula bar to total the fixed range, then press Enter.
- 4. Verify the referenced cells: Click the formula cell and review the highlighted range on the worksheet to confirm it includes the intended values.

Frequently Asked Questions
What does B29# mean in an Excel formula?
B29# means the entire spilled result of the dynamic-array formula whose anchor cell is B29. It references all results currently returned by that formula.
Does B29# include every cell below B29?
No. B29# includes only the cells in the dynamic spill range from the formula in B29. It does not continue downward to the next blank or nonblank cell.
Why does =SUM(B29#) return a #SPILL! error?
A #SPILL! error occurs when Excel cannot place the dynamic-array results in the required output area. Select the error cell, then clear or move the cells or merged ranges blocking the displayed spill area.
Can I edit one cell inside a spilled range?
No. Only the anchor cell, such as B29, contains the formula. To change spilled results, select the anchor cell and edit its formula.
How do I sum cells B29 through B49 without using a spill range?
Enter =SUM(B29:B49). The colon creates a fixed range from B29 to B49, so the formula does not depend on a dynamic-array spill result.




