| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add numbers in a column and transfer result to another column
what formula allows me to add numbers in a column and transfer the ongoing
result to another column? -- planecents |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add numbers in a column and transfer result to another column
in B1 type =sum(A:A)
any number you enter in column A will now be summed in B1 "planecents" wrote: what formula allows me to add numbers in a column and transfer the ongoing result to another column? -- planecents |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add numbers in a column and transfer result to another column
Mike
It works for the one cell in but i would like B to continue to add the values represented in the next row of A and continue to total the new value in A Thanks Bob @ planecents -- planecents "Mike" wrote: in B1 type =sum(A:A) any number you enter in column A will now be summed in B1 "planecents" wrote: what formula allows me to add numbers in a column and transfer the ongoing result to another column? -- planecents |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add numbers in a column and transfer result to another column
In B1 enter =A1
In B2 enter = B1+A2 Double-click to fill down. Gord Dibben MS Excel MVP On Fri, 2 Mar 2007 09:23:25 -0800, planecents wrote: Mike It works for the one cell in but i would like B to continue to add the values represented in the next row of A and continue to total the new value in A Thanks Bob @ planecents |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| spacing numbers in 1st column by inch intervals of 2nd column | Excel Worksheet Functions | |||
| Creating a column of numbers from a column with some blanks? | Excel Discussion (Misc queries) | |||
| How can I change column numbers back to column letters? | Excel Worksheet Functions | |||
| transfer data from one column into another column | Excel Discussion (Misc queries) | |||
| looking to assign different numbers in column B to different words in column A | Excel Worksheet Functions | |||
Linear Mode
