title: Relative formulas in Excel using Tables
body: <p>Excel provides a table range now whereby you can automatically work in a table. I have noticed that the formulas work a little differently. Whilst I can get the normal formulas to work. I am struggling to get the @ColumnName reference to be a fixed reference.  see below</p>
  <p><img src="https://i.stack.imgur.com/WJdi7.png" alt="enter image description here" /></p>
  <p>Does anyone know what this style of reference is used for, why I would not use the normal style formulas and how to define a fixed reference for this reference style.</p>