+ Reply to Thread
Results 1 to 2 of 2

Average of Changing Cell Values

  1. #1
    Registered User
    Join Date
    12-04-2020
    Location
    California, USA
    MS-Off Ver
    Office 365
    Posts
    22

    Average of Changing Cell Values

    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.

  2. #2
    Registered User
    Join Date
    10-27-2015
    Location
    Houston, Texas
    MS-Off Ver
    2013
    Posts
    6

    Re: Average of Changing Cell Values

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula to work out the average of an array from a changing cell
    By francesc in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-06-2014, 10:00 PM
  2. Continuous changing cell values - record highest and lowest values in seperate cells
    By attienel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-11-2013, 05:12 PM
  3. [SOLVED] Average Sales Using Changing Cell for ISO Week
    By ssnooze in forum Excel General
    Replies: 9
    Last Post: 05-02-2012, 02:18 PM
  4. Replies: 1
    Last Post: 04-24-2012, 09:24 PM
  5. Replies: 7
    Last Post: 08-13-2010, 01:12 PM
  6. changing cell color based on changing values
    By tvonbehren in forum Excel General
    Replies: 2
    Last Post: 09-16-2009, 12:33 PM
  7. [SOLVED] UDF code to find specific text in cell comments, then average cell values
    By bruch04 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-05-2005, 06:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1