How do I calculate the Average of a changing cell?
Cell D7 updates every 30sec with a sum value from cells A1:A3
I want to calculate the average with each 30sec update.
To stop the update I stop the macro doing the 30sec updates.
How do I calculate the Average of a changing cell?
Cell D7 updates every 30sec with a sum value from cells A1:A3
I want to calculate the average with each 30sec update.
To stop the update I stop the macro doing the 30sec updates.
I would use another column or tab in your document as a log for this value, and have the macro doing the updates to also paste the value into the log. You can figure out the last cell with a value and keep pasting the new values under it. Then just have a cell with a formula referencing the entire column where you're logging in an AVERAGE formula. Every time it updates, the value of D7 will be pasted into the log and the AVERAGE will take the new value into account.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks