Refer to columns by "field headings" in an Excel Table / eliminate dynamic named ranges

If you type = and then select the header and the existing data in that column in a table Excel will show you the syntax you need to refer to the data in the column. I have a table named ExerciseData, one of the headers is named TotalReps, If I just select the header I get:

Formula:

=ExerciseData[[#Headers],[TotalReps]]

If I select the header and all the existing data in that column I get:

Formula:

=ExerciseData[[#All],[TotalReps]]

To add up the column and have it be dynamic I type =Sum( and then select the header and the data), I then get a formula that updates when I add to the table. The formula looks like this:

Formula:

=SUM(ExerciseData[[#All],[TotalReps]])

So this should give you an idea of the syntax required if you want to type your formulas as opposed to selecting the data, which is the easiest since Excel will do the hard stuff for you.

Good Luck.