Auto Sum at the top of a column

Copper Contributor

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?

2 Replies
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])

@PatWenger Try something like

="Column Heading (" & SUM(A2:A50000) & ")"