How to sum column until current row

Question

I'm adding some values together using an Excel table. I want to have a running total on a specific column (that is, a sum of all values previous and up to the current row). It's simple to do that with ranges; all I have to do is use a relative address for the current row and an absolute cell address for the range's beginning (using the $ notation).

However, using tables, things get messy - the notation for ranges in tables uses the [[]] syntax. Is there a way to denote a range beginning at the top of the column until the current row?

Answer 1

Use the Header as your starting point:

=SUM(Table1[[#Headers],[Num]]:[@Num])