Excel Spreadsheet: How do I create a running total of numbers in a column?
Category: Computers > Software
Asked by: travisbickel-ga
List Price: $3.00
15 Aug 2003 14:50 PDT
Expires: 14 Sep 2003 14:50 PDT
Question ID: 245202
I have a column with about 100 numbers in it. I would like to have a running total of these numbers in the adjacent column. There has to be a formula for doing this without having to enter a separate formula for each cell but I sure can't figure it out. Thanks for any help you can provide.
Re: Excel Spreadsheet: How do I create a running total of numbers in a column?
Answered By: blinkwilliams-ga on 15 Aug 2003 15:14 PDT
Hi Travisbickel! The easiest way to do what you are asking is as follows: I will suppose that the column containing the numbers is column A and that the first number is in row 1. 1. Go to the cell to the right of the first number in your list (cell b1 according to my example) and enter '=a1' (or whatever the cell value of the first number in your list is). The value of cell a1 should now appear in cell b1 2. Go to the cell to the right of the second number in your list (cell b2 according to my example)and enter '=a2+b1'. The cell will now contain the sum of cells a1 and a2. 3. Now all you have to do is copy the formula in cell b2 down to the last row in your list. You can do this easily by selecting cell b2 and placing the mouse cursor on the lower right corner of the cell. Now click and drag the lower right-hand corner down until you reach the last row in your list of numbers. (Another way of copying is to select cell b2, select copy under the edit menu, select the range you wish to copy the formula to, and then select paste from the edit menu.) The cells in column b will now each contain a running total. That's it! Please request clarification if you have any questions or need a further explanation on any part of the answer. Good luck! -Blinkwilliams
rated this answer:
Thanks for the help. I really appreciate it. My problem resulted from trying to do all calculations using only the data in Column A and not incorporating the prior total from Column B.
|There are no comments at this time.|
If you feel that you have found inappropriate content, please let us know by emailing us at email@example.com with the question ID listed above. Thank you.
|Search Google Answers for|