Related:

- Running total
- Total copy - Download - File management
- Total war warhammer 3 free download - Download - Strategy
- No signal on monitor but cpu running - Guide
- Total video converter for pc - Download - Video converters
- Laptop fan running but no display - Guide

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

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 ????

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

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

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

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 .....