Column References


Single Column

references are relative by default
[@ColumnName]
[@[ColumnName With Spaces]]


Below the table add a formula that adds up all the numbers in a particular column
Formula bar you will see the table and column names automatically (not the explicit cell references)



Multiple Columns

references are absolute by default
TableName[@[ColumnName1]:[ColumnName2]]




Calculated Columns

=A2*B2
=[@Col1]*[@Col2]






© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext