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

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?

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

For versions of Excel prior to Excel 2007:

=SUM(D10:D65536)
--
Gary''s Student - gsnu200767

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

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

=SUM(D10:D10000)

HTH,
Paul

--

"JRThomas" wrote in message
...
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?

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

Hi

With XL2003 or lower, you could just use
=SUM(D10:D65536)
For XL2007 it would be
=SUM(D10:D1048576)

It might be better to create a dynamic range
InsertnameDefineName myRange Refers to =D10:INDEX(D:D,COUNTA(D:D))
The use
=SUM(myRange)

--
Regards
Roger Govier

"JRThomas" wrote in message
...
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?

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

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

=SUM(D:D)-SUM(D1:D9)

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

Hope this helps.

Pete

On Feb 4, 5:27*pm, "PCLIVE" wrote:
Just specify a row that is well beyond any point that your data will reach..

=SUM(D10:D10000)

HTH,
Paul

--

"JRThomas" wrote in message

...



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?- Hide quoted text -

- Show quoted text -

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

or:
=SUM(D:D)-SUM(D1:D9)
--
Gary''s Student - gsnu200767


"Roger Govier" wrote:

Hi

With XL2003 or lower, you could just use
=SUM(D10:D65536)
For XL2007 it would be
=SUM(D10:D1048576)

It might be better to create a dynamic range
InsertnameDefineName myRange Refers to =D10:INDEX(D:D,COUNTA(D:D))
The use
=SUM(myRange)

--
Regards
Roger Govier

"JRThomas" wrote in message
...
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?