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?