acumulating sum

[lostinmacro]

I have a list of values in collum A and I wantto keep a running talle in
another colulm B is there an easyier way to do this than putting the sum
formular in each cell in collumI B I have 400 of these.
Example
A B
3500 3500
3100 6600

 

[RagDyeR]

Since you only have 400 rows, enter this formula in B1:

=Sum($A1:A1)

Click back in B1 and hover the cursor over the little black square in the
lower right corner of the cell.

When the cursor changes from a fat white cross to a skinny black cross,
click and drag down to Row 400.

You don't have to type the formula into each individual cell.

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I have a list of values in collum A and I wantto keep a running talle in
another colulm B is there an easyier way to do this than putting the sum
formular in each cell in collumI B I have 400 of these.
Example
A B
3500 3500
3100 6600

 

[RagDyeR]

Correction:

=Sum(A$1:A1)
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Since you only have 400 rows, enter this formula in B1:

=Sum($A1:A1)

Click back in B1 and hover the cursor over the little black square in the
lower right corner of the cell.

When the cursor changes from a fat white cross to a skinny black cross,
click and drag down to Row 400.

You don't have to type the formula into each individual cell.

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I have a list of values in collum A and I wantto keep a running talle in
another colulm B is there an easyier way to do this than putting the sum
formular in each cell in collumI B I have 400 of these.
Example
A B
3500 3500
3100 6600

 

[FSt1]

hi
in cell b1 put ....=A1
in cell B2 put.....=b1+A2
copy b2 and high light column b from b3 to the end of your data. paste
done
what do you find so objectionable to this method?

regards
FSt1

 

[Gord Dibben]

If you don't want to see the total in Column B for cells that are not yet filled
in Column B, I would suggest this revision to RD's formula.

=IF(A1="","",SUM(A$1:A1))


Gord Dibben MS Excel MVP

 

[lostinmacro]

OK that formula works good but I didn't explain that I have 100 of the 400
on 4 sheets and in colums of 20.
Here is a better example:

A B C D

30.24 30.24 30.12 90.48
30.12 60.36 30.58 121.06

 

[Gord Dibben]

I don't understand your better example.

"100 of 400 on 4 sheets and in columns of 20"

4 sheets of 4 columns of 20 would be 80 per sheet or are there 5 columns of 20
per sheet?

If D1 is supposed to be a running total of A1:C1 then your addition is
incorrect.


Gord

 

[lostinmacro]

Data Sum Data Sum of B and C
Entry
Column

A B C D

30.24 30.24 30.12 90.48
30.12 60.36 30.58 121.06

There are 20 data entries in each of five columns only 2 shown with a sub
total at the bottom.
I tried making a formular =Sum(A21,C$1:C20) and it doesnt work

 

[JP]

Can't you just use =SUM(A:A) or =SUMIF(A:A,">0") in another cell? This
would keep a running sum of all the values in column A in a single
cell like you asked.


HTH,
JP

 

[lostinmacro]

Not exactly what I asked. I do have a total for column A whats important is
the progressive value in column B
See my better example on my other reply

 

[JP]

If you check your original post, you asked if there was an easier way
to have a running total cell without putting the sum formula in each
cell in column B, which was exactly what I provided to you. Now you do
want to put the running total in each cell in column B? If so then I
believe RagDyeR or FSt1 gave the correct formula.


--JP

 

[lostinmacro]

Yes it worked great but when I try a similar formula in column D it doesnt
work
=SUM(A21,D$11)

 

[RagDyeR]

If A21 is a carry-over from the previous column of calculations, maybe
you'll want to make it absolute also:

=Sum($A$21,D$11)

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Yes it worked great but when I try a similar formula in column D it doesnt
work
=SUM(A21,D$11)

 

[lostinmacro]

That was the problem thanks so now when I do the other sheets
I can referance sheet4 where I have a grand total like this.

=SUM(Sheet!4$D$27,A$1:A1)

 

[David Biddulph]

Are you sure you mean that, and not =SUM(Sheet4!$D$27,A$1:A1) ?

Two suggestions for whenever you post here again:
Firstly don't try to retype a formula, as you are likely to make mistakes in
doing so. Copy and paste to or from the formula bar.
Secondly, please include enough of the previous message to put your reply
into context. Any reasonable guide to newsgroups and netiquette will give
you advice on quoting and snipping.