Running total [Closed]

Report
-
 Trowa -
Hello,
can I have a running total in a cell in a row even if one of the cells has a formula in it? If so how
I want to add numbers from two different cells
thanks
jaxs

3 replies

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
212
Suppose you have values and formula like this

A1= 1
A2= 2
A3= A1+A2 (Formula) = 3
A4= 12
A5= A3+A4 (Summing A3 which have a formula and A4 which have a value)

Were you asking this query ????




To keep it short.....I need a formula that will let me add numbers and keep adding more numbers
like a1= 6
a2=6
add another number
input a1=3
now a2=9 keeps 6 and adds 3


input a1=5
now a2=14 keeps 9 and adds 5

so a2 keeps its' current number and adds the input number
Hi Jaxs,

In my opinion there are three things you can do.

1. Put in cell A2 the following formula: =(14+9+5)
Each time you get a new number add it in the formula: =(14+9+5+next number+....)

2. Create an extra column.
In column A you put your numbers, then you put the formula in B1: =(A1:A100)

3. If you really want to use a macro, copy paste this code into a module of your workbook:
Sub Calculate()
Sheets("Sheet1").Range("A2").Value = Sheets("Sheet1").Range("A2").Value + Sheets("Sheet1").Range("A1").Value
End Sub
After inputting your number in A1 run the macro: ALT+F8 and select Calculate.

Let me know if this helps you.

Best regards,
Trowa
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
212
May be that can be achieved thru a macro but I am not expert in macro and someone else can give a better solution .....