Results 1 to 9 of 9

Running average formula (in same cell)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-08-2006
    Location
    UK
    MS-Off Ver
    2013
    Posts
    204

    Running average formula (in same cell)

    I need a formula that will show the average of a series of data:

    In column E, a series of data is entered one at a time (E9:E13) which is calculated from the value of other cells.

    E14 is to show the average of data entered between E9:E13. But it needs to show the average only for total number of figures entered (so if E9:E11 has been entered, E14 will show the average of E9:E11, similarly if E9:E12 has been entered, then B1 will show the average of E9:E12).

    The default value of cells in row E is 0 which may complicate matters, as 0 is a valid entry.

    I know I could have several cells for each average, but that is not what is needed, nor do I want to have to manually change the range that E14 refers to.

    Can anyone help? I've attached the spreadsheet if it helps.
    Attached Files Attached Files
    Last edited by wonderdunder; 02-27-2011 at 12:28 PM.

Thread Information

Users Browsing this Thread

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

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