Results 1 to 11 of 11

Counting with Multiple Criteria - Months and Date Differences

Threaded View

  1. #1
    Registered User
    Join Date
    02-13-2015
    Location
    Seattle, WA
    MS-Off Ver
    2013 (Work) & 2016 (Home)
    Posts
    33

    Counting with Multiple Criteria - Months and Date Differences

    Good afternoon everyone,

    I have a large spreadsheet with a lot of data that I'm trying to condense into whether a specific job was completed on time or late. In my example WB, on the "Data" Sheet Column A, I currently have "Due Date" and in Column B I have "Complete Date". In the "Summary" Sheet, I am trying to make like a summary page where I have "Completed On Time" and "Completed Late" broken out for 12 months. For each Summary, here is what I am trying to do:

    Completed On Time - Count all the items where the Complete Date is less than or equal to the Due Date for each month.
    Completed Late - Count all the items where the Complete Date is more than the Due Date for each month.

    I would also prefer having a cell reference in the formula to the month listed (August, September, etc.) but that is not 100% necessary. I'm pretty sure this is a SUMPRODUCT formula, but I've very rarely used it in my time so I don't know the many nuances with it.

    I have attached a sample WB with some example data points. Thanks for your help!
    Attached Files Attached Files
    Last edited by kujoking7; 08-04-2017 at 05:54 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 05-26-2013, 09:48 AM
  2. Counting Multiple Criteria with Date and Text Values
    By JERICA in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-05-2013, 04:17 PM
  3. Counting with Multiple Criteria (including Date Ranges and Text)
    By GABBA in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-05-2013, 02:56 PM
  4. Replies: 2
    Last Post: 09-21-2011, 04:19 PM
  5. Replies: 5
    Last Post: 05-23-2011, 12:04 PM
  6. Counting Months year to date.
    By WKM in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 05-18-2010, 03:08 AM
  7. Counting months up to a certain date
    By TTej in forum Excel General
    Replies: 7
    Last Post: 05-07-2008, 05:40 AM
  8. calculate date differences in years and months
    By Joyce in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-14-2005, 02:06 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