+ Reply to Thread
Results 1 to 2 of 2

using sumifs/countifs to calculate average days between two columns of dates

  1. #1
    Registered User
    Join Date
    07-19-2011
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    37

    using sumifs/countifs to calculate average days between two columns of dates

    I need to calculate the average days from two columns of dates based on a fixed date range.

    I’ve been advised that a combination of countifs and sumifs to calculate the average is the way to go but can’t quite get to grips with this.
    My data:

    G5: start of date range: 01/04/2015 (>=)
    G6: end of date range: 01/07/2015 (<)
    R: The first columns of dates I need to use to calculate the average for the quarter
    X: The second column of dates for the average calculation

    Any help with this would be greatly appreciated.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: using sumifs/countifs to calculate average days between two columns of dates

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

+ 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. Calculate average of the last valid 30 days
    By b.kibler in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-11-2015, 08:13 PM
  2. [SOLVED] formula which can calculate last 7 days average
    By kiany406 in forum Excel General
    Replies: 1
    Last Post: 05-22-2015, 05:03 PM
  3. Countifs and Sumifs of the past 30, 60, 90 days
    By asvallini in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-23-2015, 03:12 PM
  4. [SOLVED] COUNTIFS between 2 dates - how to calculate for blank dates
    By HeyInKy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-13-2014, 12:03 AM
  5. Replies: 1
    Last Post: 11-01-2012, 03:41 PM
  6. Countif and Average function to calculate dates into days
    By codesRus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-01-2012, 04:06 PM
  7. Calculate Average days
    By mrcois in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-13-2010, 02:07 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