How to make Excel formulas with name references work without Implicit intersection operator_ @

Question

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 that it always works without the @-signs?

Would appreciate any help.

hansvogelaar · Answer

Aleksiii&nbsp;
How are item1 and item2 defined?

aleksiii · Answer

Item 1 is defined as the whole row 1 in the sheet and item 2 is defined as row 2

aleksiii · Answer

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

patrick2788 · Answer

If you're working in a table, there's no spilling. Tables are scalar-based.

hansvogelaar · Answer

Aleksiii&nbsp;
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

Forum Discussion

How to make Excel formulas with name references work without Implicit intersection operator_ @

Share

Resources