| Home > Forum Home > Analyzing Corporate Financial Data > Circular SUM | Share |
Circular SUM
Excel Help for Circular Sum in Analyzing Corporate Financial Data
| Forum Topic | Post Reply Login |
Circular Sum | Rate this: (3/5 from 1 vote) |
 | How 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 Jessika on | ||
| Replies - Displaying 1 to 1 of 1 | Order Replies By: Most Recent | Chronological | Highest Rated |
| Rate this: (3/5 from 1 vote) 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 [email protected] on |
| Displaying page 1 of 1 |
| Find relevant Excel templates and add-ins for Circular SUM in the Excel Business Solutions Directory |