in excel, I would like to have a cell maintain a sum of results over multiple recalculations. Lets say after a worksheet recalculates, cell c4 has either a 1 or a 0 based on its formula. In another worksheet I want to 1) count the number of recalculations and 2) keep a record of the sum of values displayed in cell c4. So the cell in the second worksheet would have a formula similar to = "itself" + c4. that is if the cell was f16 the formula would be "=f16 + c4" The Problem I am having is that Excel will not allow a cell to reference itself, that there is no memory for the value in the cell other than the cell itself. How can I work around this???? Also how would I keep a count of each time the worksheet recalculated???
Bookmarks