| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Incorporating the first 40 out of 250 rows in column values | Excel Worksheet Functions | |||
| conditional formatting rows on column values... | New Users to Excel | |||
| VBA to set AutoFilter to List all rows with same values in column? | Excel Discussion (Misc queries) | |||
| Transpose unique values in one column/mult. rows into a single row | Excel Worksheet Functions | |||
| Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
Linear Mode
