Prev: Sumif using Values, but returning text or values
Next: SUMIF w/multiple conditions
From: bobby02169 on 14 Apr 2010 14:31
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
From: Gary Brown on 14 Apr 2010 15:20
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
From: bobby02169 on 14 Apr 2010 17:10
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
 | 
Pages: 1
Prev: Sumif using Values, but returning text or values
Next: SUMIF w/multiple conditions