COUNTIFS to segregate the total value into different categories

Hello,

So I have data showing the mobile phone use of a business' employees for one month.

The total number of calls made by employees was 1,724
I want to segregate this number into different categories of time for better understanding of the data.

Categories:
1 - 9 seconds

Please Login or Register  to view this content.

10 - 59 seconds

Please Login or Register  to view this content.

1:00 - 4:59 minutes

Please Login or Register  to view this content.

5:00 - 09:59 minutes

Please Login or Register  to view this content.

10:00+ minutes

Please Login or Register  to view this content.

So essentially the 1,724 will be split based on how long each of those calls were.

I've had moderate success with the COUNTIFS function, however, the total of the categories equals 1,731 which is accounting for 7 more calls...

I used to format the formulae with ">=" e.g. 1 - 9 sec would be: >=00:00:01 / <=00:00:09
but this returns LESS than 1,724

I'm confused as to what's going wrong? The times I've put in each formula don't seem to "over wrap" each other, yet some calls are counted more than once.

Is there a way to do this without COUNTIFS? Or have I made an obvious mistake?

Any help would be greatly appreciated

Many thanks

=COUNTIF($A:$A,">="&$D5)-SUM($E6:E$50) for 10 min, pull up

This works, I appreciate your fix.

However, when I paste my 1,724 duration values into the sheet you made, the 5 formulae's total equals 1,297 instead of 1,724

So... the issue must be with my data.

Thanks again

there aren't any zero length calls? or the duration is effected by calls over midnight (if it is calculated elsewhere?)

There are zero length calls but the formula that's used to calculate them is correct and doesn't need amending so I just left it out.
I have a separate COUNTIF to calculate the number of zero length calls.

Sorry for leaving that out

No I was wondering if the discrepancy between 1724 lines and 1297 was that there were some zero length calls and they account for the difference (427). No need to appologize!

I literally have zero common sense while I'm at work haha.

Yeah that was it, I did a COUNTIF for the zeroes and it totalled 427.

Which means tim2011101's formulae works! Thank you v much both of you