# Counting a Time Range with COUNTIFS or SUMIFS

Show 40 post(s) from this thread on one page
Page 2 of 2 First 12
• Aug 23rd, 2019, 01:22 PM
Josh08
Re: Counting a Time Range with COUNTIFS or SUMIFS
Quote:

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!
• Aug 23rd, 2019, 01:32 PM
DanteAmor
Re: Counting a Time Range with COUNTIFS or SUMIFS
Quote:

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")
• Aug 23rd, 2019, 01:51 PM
James006
Re: Counting a Time Range with COUNTIFS or SUMIFS
Quote:

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!