+ Reply to Thread
Results 1 to 2 of 2

Average formula for last 15 days excluding blanks

  1. #1
    Registered User
    Join Date
    07-14-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    9

    Average formula for last 15 days excluding blanks

    Hi there,

    I'm trying to create a formula that takes the last 15 days worth of data. I can't just use the Average formula and select the last 15 rows as some rows will be blank and I need the average of the last 15 data points, even if it takes more than 15 days to get it. If I use the last 18 days there will definitely be 15 data sets in there, but I don't know what the formula would be to create an average for it.

    Thanks a lot!
    Attached Files Attached Files

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Average formula for last 15 days excluding blanks

    Enter this formula in B20 and pull it to the right

    =AVERAGEIFS(B2:B19,$A2:$A19,">"&MAX($A2:$A19)-15,B2:B19,">0")
    Last edited by AlKey; 12-22-2014 at 06:47 PM.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ 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. Replies: 4
    Last Post: 06-11-2014, 07:56 AM
  2. Replies: 6
    Last Post: 08-16-2013, 10:04 PM
  3. [SOLVED] Formula for Last 30 Days Excluding Saturday, but including Sunday
    By AlphaSkidz in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-08-2013, 02:23 PM
  4. [SOLVED] Calculate 'average' between data range of days but excluding weekends(?)
    By iliasark in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-08-2013, 04:39 AM
  5. [SOLVED] formula to calculate # of days between dates, excluding holidays
    By abs2299 in forum Excel General
    Replies: 9
    Last Post: 10-11-2012, 03:59 AM

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