Forum Discussion
PatWenger
Sep 22, 2022Copper Contributor
Auto Sum at the top of a column
I am trying to create a total for the columns in a worksheet at the top instead of the bottom of the column. Can anyone help?
- Juliano-PetrukioBronze ContributorConvert the range to table (Insert>Table) and use the columns with values as reference for your calculation.
Considering you table was named as MyTable and there is a column with values named as ColumnWithValues
=SUM(MyTable[ColumnWithValues])