how to count how many time a cell has been recalculated, also cell self reference

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

unfortunately, there are 270 cells that I am referencing, I tried cell c4 "=bc4 + c58" where bc4 "=c4" , but excel will not allow "indirect reference" either. I don't want to create a database as the iterations could be in the thousands. I just want a counter that sums the 1 and 0 that come up as the spreadsheet recalculates.