sum a column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alex - 25 Oct 2006 10:14 GMT

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

Reply to this Message

Gary''s Student - 25 Oct 2006 10:31 GMT

=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.

Signature

Gary's Student

> Hi i have a column of indeterminant number of rows. My total cell is in Row
> 2
[quoted text clipped - 4 lines]
>
> A

Reply to this Message

Alex - 25 Oct 2006 10:34 GMT

Sorted thanks

A

> Hi i have a column of indeterminant number of rows. My total cell is in
> Row 2
[quoted text clipped - 4 lines]
>
> A

Reply to this Message