Thread: Counting a Time Range with COUNTIFS or SUMIFS Thanks:  4 Post #5330711 (1)Post #5330771 (1)Post #5330683 (1)Post #5330686 (1) Likes: 0

1. Re: Counting a Time Range with COUNTIFS or SUMIFS

Originally Posted by James006
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. Re: Counting a Time Range with COUNTIFS or SUMIFS

Originally Posted by Josh08
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")

3. Re: Counting a Time Range with COUNTIFS or SUMIFS

Originally Posted by Josh08
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!