+ Reply to Thread
Results 1 to 3 of 3

COUNTIF between Hrs and Day

  1. 05-04-2020, 12:28 PM #1
    jani.pk
    jani.pk is offline
    Registered User
    Join Date
    08-09-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2016
    Posts
    70

    COUNTIF between Hrs and Day

    i have attach the sheet for the experts of this forum to ease.
    what i want is in the ANALYSIS sheet. i have mentioned the timeslot and day and based on these criteria i need the total number entries fall under this criteria given in DATABASE.

    please let me know if there is any confusion.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-04-2020, 12:41 PM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: COUNTIF between Hrs and Day

    Attached is one way to do it. COUNTIFS is the function, but you needed corrections to your data sheet "time" column and to the chart itself.
    Attached Files Attached Files
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
  3. 05-04-2020, 02:34 PM #3
    jani.pk
    jani.pk is offline
    Registered User
    Join Date
    08-09-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2016
    Posts
    70

    Re: COUNTIF between Hrs and Day

    Great Work. Thankyou!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Adding a COUNTIF function to an existing IF AND COUNTIF Formula...
    By Ourkid123uk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-24-2018, 10:09 AM
  2. How can I make =IF(COUNTIF(B$2:B2,0)>=1,0,COUNTIF(A$2:A2,0)) workwhen copying it further?
    By Dussy in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-27-2017, 07:04 AM
  3. Faster if/countif formula for flagging uniques - countif too slow
    By Speshul in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-19-2015, 01:44 PM
  4. Combining a Date Range COUNTIF and a general COUNTIF
    By jacobtom in forum Excel General
    Replies: 1
    Last Post: 09-15-2011, 05:06 PM
  5. Adding a CountIF to a formula that is already Countif
    By Cmorgan in forum Excel General
    Replies: 4
    Last Post: 06-01-2011, 09:34 AM
  6. COUNTIF or not to COUNTIF on a range in another sheet
    By Ellie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-15-2005, 05:06 PM
  7. Countif w/ Multiple Criteria-How do I use countif
    By Patrick_KC in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-09-2005, 05:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1