Structured Referencing of a portion of a colum

[protrader]

What is the syntax to reference a table's column, not the whole column but the portion from row 1 to the current row?

Let's say we are in the 5th row of a table, in column "MyColumn"
Equivalent to 6th row and 2nd column (column B) in the spreadsheet

Referencing the cell will be [@MyColumn]
Referencing the whole column will be [MyColumn]
What is the structured referencing that would generate the same result such as $B$1:$B6 ?

 

[Domenic]

Try...

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

If you actually meant $B$2:$B6, try the following instead...

=SUM($B$2:Table1[@MyColumn])

or

=SUM(INDEX(Table1[[#All],[MyColumn]],2):Table1[@MyColumn])

Hope this helps!