CODEWITHSUNDEEP
excelsum
missingsemicolon
missingsemicolon

Reputation: 500

Sum a column and put the sum on top of column for dynamic number of rows

Is there any way to put the sum of a column values on the top of same column. For ex: I want to add the values on column A and put the total in the cell A1 and number of rows on column A is dynamic.

Upvotes: 2

Views: 3393

Answers (1)

Gary's Student
Gary's Student

Reputation: 96753

In A1 enter:

=SUM(A2:A1048576)

For versions of Excel 2007 and later.

Upvotes: 1

Related Questions