Google Answers Logo
View Question
Q: Excel Spreadsheet: How do I create a running total of numbers in a column? ( Answered 5 out of 5 stars,   0 Comments )
Subject: 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
Posted: 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.
Subject: 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
Rated:5 out of 5 stars
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!

travisbickel-ga rated this answer:5 out of 5 stars
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.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy