Forum Discussion
Using a hash in a sum formula
I've inherited a spreadsheet for work and noticing some weird use of formulas. One of them I'm hoping someone can explain. I have a column like below. The last cell basically is a sum of all the c...
lfk73 With MS365, the hash symbol is used to refer to a "spill range", which is the result of a dynamic array formula. Cell B29 in this example has a formula that returns multiple results (array), which extends to cell B49. Only the first cell in the array contains the formula, and only the first cell can be edited. Attempting to change the value of any other cell within the spill range will result in the #SPILL! error.
For more information, please see: https://www.xelplus.com/excel-hash-sign-formulas/