sum a column

  • Thread starter Thread starter Alex
  • Start date Start date
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
 
=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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What is the "--" (double dash) in MS Excel formula? 2
SUM Char 9
Sum totals 2
Is it possible to SUM based on value of another column? 3
Find last column matching criteria 2
Sum Column above current cell dynamically using function call 7
sum of multiple rows 2
Excel Help to copy information from one row at a time to another sheet 1

Back
Top