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]
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext