Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello everyone,
I am using excel 2007 I would like to know how to do the following if possible have column A add column B and put the total in column C and then put the amount of column C in column A of the next row. EX: 1+1=2 in row 1 then automatically have it put 2 in row 2 column A Thanks in advance if anyone can help. Bobby |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Cell C1: = +A1 + B1
Cell A2: = +C1 -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "bobby02169" wrote: Hello everyone, I am using excel 2007 I would like to know how to do the following if possible have column A add column B and put the total in column C and then put the amount of column C in column A of the next row. EX: 1+1=2 in row 1 then automatically have it put 2 in row 2 column A Thanks in advance if anyone can help. Bobby |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks, that worked great.
"Gary Brown" wrote: Cell C1: = +A1 + B1 Cell A2: = +C1 -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "bobby02169" wrote: Hello everyone, I am using excel 2007 I would like to know how to do the following if possible have column A add column B and put the total in column C and then put the amount of column C in column A of the next row. EX: 1+1=2 in row 1 then automatically have it put 2 in row 2 column A Thanks in advance if anyone can help. Bobby |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting rows | Excel Discussion (Misc queries) | |||
Formatting Rows | New Users to Excel | |||
Rows not formatting all the way down | Excel Worksheet Functions | |||
Formatting to highlight rows | Excel Discussion (Misc queries) | |||
Conditional Formatting for rows... | Excel Discussion (Misc queries) |