+ Reply to Thread
Results 1 to 3 of 3

Need addtional criteria to count where "Actual" dates earlier that "Scheduled" DATE

  1. #1
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365
    Posts
    1,327

    Need addtional criteria to count where "Actual" dates earlier that "Scheduled" DATE

    As shown on the attached SUMMARY sheet, Product is in A2, Order Date in B1.

    Following formula works perfectly in counting how many records in Col A of Schedule sheet match the product in A2, and were ordered in the month in B1:

    =COUNTIFS(Product,$A2,Ordered,">="&B$1,Ordered,"<="&EOMONTH(B$1,0))

    What's the extra element that will find how many of those ALSO have a "Received" date (Col D of the Schedule) earlier than the Scheduled date (Col C of the Schedule), given that both dates vary from row to row?

    All suggestions, solutions and pointers welcome as ever

    Ochimus
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,852

    Re: Need addtional criteria to count where "Actual" dates earlier that "Scheduled" DATE

    Try this in B4 and copied right:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    BSB

  3. #3
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365
    Posts
    1,327

    Re: Need addtional criteria to count where "Actual" dates earlier that "Scheduled" DATE

    Badly,

    Many thanks for prompt solution.

    Can now close this as solved.

    Ochimus

+ 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: 5
    Last Post: 02-05-2019, 12:03 AM
  2. Replies: 2
    Last Post: 07-24-2017, 02:19 AM
  3. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  4. Replies: 1
    Last Post: 01-22-2016, 09:21 AM
  5. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  6. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM
  7. Replies: 7
    Last Post: 05-13-2006, 05:02 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