Results 1 to 7 of 7

Average last 14 numbers from changing amount of cells

Threaded View

  1. #1
    Registered User
    Join Date
    07-14-2010
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    3

    Average last 14 numbers from changing amount of cells

    I want to average the last 14 numbers in a column that is constantly growing. However, the column has many spaces in it that change amounts of spaces. So I cannot say =AVERAGE(C50:C63).

    So for example my column might be

    119
    (blank)
    (blank)
    (blank)
    100
    (blank)
    (blank)
    147
    (blank)
    (blank)
    (blank)
    (blank)
    75

    So I can't even say 28 lines for 14 numbers, or any exact amount. The number of spaces changes daily. But I can have the last 14 (no more, no less) numbers, or it won't help me.

    Any suggestions?
    Last edited by fallon225; 07-14-2010 at 08:55 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