add numbers in a column and transfer result to another column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

what formula allows me to add numbers in a column and transfer the ongoing
result to another column?
 
in B1 type =sum(A:A)

any number you enter in column A will now be summed in B1
 
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
 
In B1 enter =A1

In B2 enter = B1+A2

Double-click to fill down.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Networkdays and misleading results from blank column 3
Excel Subtracting multiple columns from another column 3
Help needed 0
Calculate total by row number 4
Solve for a number (x) 2
How to count the maximum number flanked by zeros 9
SUMIF with criteria "<>" & "=" 4
Excel VBA 1

Back
Top