+ Reply to Thread
Results 1 to 6 of 6

Countifs > Today()

  1. #1
    Registered User
    Join Date
    09-22-2019
    Location
    Klerksdorp, South Africa
    MS-Off Ver
    MS Office Pro Plus 2019
    Posts
    7

    Countifs > Today()

    How many orders for ITEM_1 are there after TODAY() from Companies that are supposed to order?
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,748

    Re: Countifs > Today()

    Kindly unlock the sheet so that ranges can be selected.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,731

    Re: Countifs > Today()

    Similar to formula above (E12), just add date criteria:

    D
    E
    12
    How many orders for ITEM_1 should there be?
    5
    13
    How many orders for ITEM_1 are there after TODAY() from Companies that are supposed to order?
    2


    D
    E
    12
    How many orders for ITEM_1 should there be?
    =SUM(SUMIFS(B2:B8,$A$2:$A$8,$D$2:$D$11))
    13
    How many orders for ITEM_1 are there after TODAY() from Companies that are supposed to order?
    =SUM(SUMIFS(B2:B8,$A$2:$A$8,$D$2:$D$11)*(E2:E11>TODAY()))
    Sheet: Sheet3


    E13:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    array formula have to be accept with CSE (as E12).
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  4. #4
    Registered User
    Join Date
    09-22-2019
    Location
    Klerksdorp, South Africa
    MS-Off Ver
    MS Office Pro Plus 2019
    Posts
    7

    Re: Countifs > Today()

    Works 100%. Thanks.

  5. #5
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Countifs > Today()

    Hi,

    One way with CSE

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  6. #6
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,731

    Re: Countifs > Today()

    Quote Originally Posted by KErasmus View Post
    Works 100%. Thanks.
    Happy to help.

+ 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. [SOLVED] Please help!!! Countifs formula for the columns contains date today
    By kylechace in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2017, 05:05 AM
  2. COUNTIFS before today and after 01/01/15
    By -jack in forum Excel General
    Replies: 3
    Last Post: 12-13-2016, 12:11 PM
  3. Countifs function to count values done today on a particular hour
    By biznez in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-26-2016, 10:40 PM
  4. [SOLVED] COUNTIFS, EOMONTH and TODAY :)
    By natonato in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-11-2015, 02:48 AM
  5. [SOLVED] Using greater than or less than today as a criteria in a countifs
    By santanicopandimonium in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-05-2014, 02:48 AM
  6. [SOLVED] COUNTIFS using (TODAY()-5days) Filter or equivalent
    By Stymple Tweed in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-15-2013, 08:34 AM
  7. Replies: 0
    Last Post: 12-16-2011, 09:01 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