Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Counting a Time Range with COUNTIFS or SUMIFS

  1. #11
    New Member
    Join Date
    Aug 2019
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Counting a Time Range with COUNTIFS or SUMIFS

    Quote Originally Posted by James006 View Post
    Without your file .. difficult to guess what is in front of your eyes ...

    Most probably for 2nd shift ... you should either >= or <=

    and your third shift should be the Total minus both 1st and 2nd Shift ...
    I believe that adding the "=" has done the trick. Not so much for the formula that I had for the 3rd shift but instead I did what you suggested. Total - (1st shift _ 2nd shift). Now the totals are adding up. The 1 I was missing from 2nd shift populated by adding the = for the greater than or equal to and less than or equal to.

    Thank you James006!

  2. #12
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,260
    Post Thanks / Like
    Mentioned
    71 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Counting a Time Range with COUNTIFS or SUMIFS

    Quote Originally Posted by Josh08 View Post
    I believe that adding the "=" has done the trick. Not so much for the formula that I had for the 3rd shift but instead I did what you suggested. Total - (1st shift _ 2nd shift). Now the totals are adding up. The 1 I was missing from 2nd shift populated by adding the = for the greater than or equal to and less than or equal to.

    Thank you James006!
    My suggestion in post #2 was to use those equalities:

    =COUNTIFS(C2:C19,">=06:00",C2:C19,"<=15:00")
    Regards Dante Amor

  3. #13
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    3,370
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Counting a Time Range with COUNTIFS or SUMIFS

    Quote Originally Posted by Josh08 View Post
    I believe that adding the "=" has done the trick. Not so much for the formula that I had for the 3rd shift but instead I did what you suggested. Total - (1st shift _ 2nd shift). Now the totals are adding up. The 1 I was missing from 2nd shift populated by adding the = for the greater than or equal to and less than or equal to.

    Thank you James006!
    Glad you could fix your problem ...

    Thanks for your Thanks

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •