what is [@[cellheader]] format in formulae

[sharbie]

I have a spreadsheet that previously used the cell coordinate for calculations, e.g. D4 = A4 + B4 + C3.

Now it is using the above format so that the references have changed to reference the column header name. See attached example.

I've worked out that these must be the relative cell references, but can you please explain why the spreadsheet is using this format all of a sudden and what this format is called - I couldn't find anything when I searched.
Thanks.

[alansidman]

This would suggest to me that the file in question (not the file attached) is set up as a Table and not a range. This is the common way excel treats formulas that involve Tables.

[sktneer]

This is called Table Structured Reference.

[sharbie]

Yes, you're right. I didn't know that. Thank you.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.