Running total

Closed
jaxs - Jun 30, 2009 at 10:01 AM
 Trowa - Jul 6, 2009 at 09:16 AM
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

mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
159
Jul 1, 2009 at 12:50 AM
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 ????




0
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
0
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
0
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
159
Jul 5, 2009 at 10:37 PM
May be that can be achieved thru a macro but I am not expert in macro and someone else can give a better solution .....

0