| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum a column
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum a column
=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. -- Gary's Student "Alex" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum a column
Sorted thanks
A "Alex" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro | Excel Discussion (Misc queries) | |||
| Stock data manipulation | Excel Worksheet Functions | |||
| Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Linear Mode
