# 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
Related:

## 3 responses

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165
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 ????

To keep it short.....I need a formula that will let me add numbers and keep adding more numbers
like a1= 6
a2=6
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
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165
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 .....