run total in excel

  • Thread starter Thread starter grizzly6969
  • Start date Start date
G

grizzly6969

Iis there a formula that will keep a running total in excel
example:
C2=5 B2=5 total in A2 =10 now if I change C2 to 8 then A2 will be 18 and
if I change B2 to 12 then A2 will = 30
I dont want to use VBA if at all possible
 
Hi Grizzly
In A2 type =c2+b2
Any number you will type in C2 & b2 will be added to A2
Regards
John
 
Thanks John but this will not keep a running total. - this will only add the
two numbers put in B2 and C2 together
 
I'm not sure if this is what you're looking for but . . .

Assume your numbers are in column A starting with A1. In B1 put =A1. Then
in B2 put =B1+A2 and copy that down as far as you need in B.

The end result will look sort of like:

4 4
5 9
5 14
6 20
7 27
 
Back
Top