sum a column

A

Alex

Hi i have a column of indeterminant number of rows. My total cell is in Row
2
Starting at Row 3 how do I express a formula that will sum the column
irrespective of how many rows are subsequently added?

Thanks

A
 
G

Gary''s Student

=SUM(A3:A65536)

By the way, what you are doing is good. Putting the sum at the top means
never having to move the fomula as more rows are added.
 
Top