Related:
- Running total
- Total war warhammer 3 free download - Download - Strategy
- Total copy - Download - File management
- No signal on monitor but cpu running - Guide
- Total video converter for pc - Download - Video converters
- Psp running slow - Guide
3 responses
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
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
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
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
166
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 .....
