Forum Discussion

PatWenger's avatar
PatWenger
Copper Contributor
Sep 22, 2022

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?

  • Convert 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])

Resources