Forum Discussion
How to make Excel formulas with name references work without Implicit intersection operator_ @
Currently the formula looks like =@item1 + @item2, and i want it to work when i just write =item1 + item2. But when i remove the @-sign from the formula, i get #SPILL error. How to fix in settings so...
How are item1 and item2 defined?
Item 1 is defined as the whole row 1 in the sheet and item 2 is defined as row 2
- Then i get spill error in row 3 where the formula is. It is supposed to calculate the sum of the cells in row 1 and 2 in each column
The formula should work if:
- The cell with the formula is in column A, and
- The rest of the row of that cell is empty.
But I wouldn't use entire rows:
- The formula will spill to all 16384 columns; this is inefficient.
- It will return 0 in columns in which row 1 and row 2 are empty