ExcelBanter - Count the number of times a cell has been up-dated

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Count the number of times a cell has been up-dated (https://www.excelbanter.com/excel-discussion-misc-queries/451279-count-number-times-cell-has-been-up-dated.html)

Lionel.Rose

Count the number of times a cell has been up-dated

Using Excel 10 I have a total spreadsheet with a total which is updated via a template.
What I would like to do is count the number of times the total spreadsheet has been updated. Then use that number to divide into the grand total to get an average of all data entered.
Regards

Lionel

All times are GMT +1. The time now is 11:02 AM.