Thread: sum a column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default sum a column

=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.
--
Gary's Student


"Alex" wrote:

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