Home > Forum Home > Analyzing Corporate Financial Data > Circular SUM Share

Circular SUM

Excel Help for Circular Sum in Analyzing Corporate Financial Data


Forum TopicPost Reply Login

Circular Sum

Rate this:
(3/5 from 1 vote)
ConfusedHow can I calculate a sum in the same cell
Lets say I type th enumber 4 in cell A1
How should I proceed if I want a sum to be calculated in the cell A1
I mean, I want the formula to give me 5 if I type the number 1 in cell A1 (4+1) = 5
If i type 5 in cell A1 the result should be the content of cell A1 added to 5 which will give me 10.

Please help
Thanks
Jessika
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
Confused
Rate this:
(3/5 from 1 vote)
suppose you already have 4 in A1 type in B1 also 4
righclick sheet tab
click VIEWCODE
copy paste this code in the window which appears
[code]
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Address <> "$A$1" Then GoTo line1
Target = Target.Offset(0, 1) + Target
Target.Offset(0, 1) = Target
line1:
Application.EnableEvents = True
End Sub
[/code]
now change the value in A1 see what you get 
again change and see 
post feedback

 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Circular SUM in the