How can I SUM all values in a column where the rows...

[JRThomas]

I am trying to write a formula that will sum all cells in a column no matter
how long the worksheet becomes. I have this as the current entry:
=SUM(D10

What would I enter for the value after the colon?

 

[Gary''s Student]

For versions of Excel prior to Excel 2007:

=SUM(D1065536)

 

[PCLIVE]

Just specify a row that is well beyond any point that your data will reach.

=SUM(D1010000)

HTH,
Paul

 

[Roger Govier]

Hi

With XL2003 or lower, you could just use
=SUM(D1065536)
For XL2007 it would be
=SUM(D101048576)

It might be better to create a dynamic range
Insert>name>Define>Name myRange Refers to =D10:INDEX(D,COUNTA(D))
The use
=SUM(myRange)

 

[Pete_UK]

If the formula is not in column D, then you could use this:

=SUM(D)-SUM(D19)

i.e. add up the complete column and take away any numbers in the first
9 cells.

Hope this helps.

Pete

 

[Gary''s Student]

or:
=SUM(D)-SUM(D19)