@ sign in Table Reference?

As that post you discovered said, the @ is to specify 'This Row'.

Let's say you have this data:

Please Login or Register  to view this content.

Now add a third column Col3. In the second row, click the AutoSum button and you'll get this formula automatically:

Formula:

Please Login or Register  to view this content.

This will automatically fill in down the column and give you:

Please Login or Register  to view this content.

Now delete the @ from the formula to make it this:

Formula:

Please Login or Register  to view this content.

Now what you'll have is this:

Please Login or Register  to view this content.

As you can see, the formula is now summing all of Col1 and Col2, not just the numbers in the same row.

Does that help explain it at all?

If you want to delve into it further, these are worth looking at:
Microsoft support site: https://support.office.com/en-gb/art...3-C8AE6D2B276E
A page with lots of examples of Table references (though it can get a bit difficult to follow in places): http://peltiertech.com/structured-re...-excel-tables/


Edit: attached is a file showing the data/formulae I gave above - look at the difference between Col3 and Col4

You're welcome, glad to be of help.
Thanks for the feedback and the rep.