acumulating sum

  • Thread starter Thread starter lostinmacro
  • Start date Start date
L

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
 
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
 
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
 
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
 
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
 
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
 
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
 
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
Click to expand...

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
 
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
 
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
 
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
 
Yes it worked great but when I try a similar formula in column D it doesnt
work
=SUM(A21,D$1:D1)
 
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$1:D1)

--

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$1:D1)
 
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)
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inserting a value in a cell when 2 others cell match a certain cri 3
sum of a cell if 2 cells meet a condition 4
function range 1
Acumulative value 1
function range 2
Excel How to add numbers in same cell? 2
sumif with a lookup formula 5
Function Range Lookup 2

Back
Top