Call Report Need to count cells a range of times

[mr_ITtoyou]

I am having issues setting up a formula to count cells of a range of times, under column (Queue Time) E2. Example first cell count for time range 0:00:00-0:20:59 total, second cell count for time range 0:21:00-0:39:59 total. I set up the cell count beyond the amount of data because the total amount calls are not the same month to month. I am getting a total of 3088 when the count of cells with time 0:00:00-0:20:59 total is 2929.

Master RSA Call Report (002).xlsx
	A	B	C	D	E	F	G	H
1	Call Start Time	Call End Time	Application Name	CSQ Names	Queue Time	Agent Name	Talk Time
2	6/1/2021 13:43	6/1/2021 13:56	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:01	Gloria Gutierrez Herrera	0:13:05
3	6/17/2021 14:12	6/17/2021 14:23	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:01	Gloria Gutierrez Herrera	0:08:34
4	6/21/2021 13:21	6/21/2021 13:27	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:01	Traci Mizer	0:05:37	Total less than 00:21:00 = 3088
5	6/30/2021 14:40	6/30/2021 14:45	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:01	Traci Mizer	0:03:58	Total greater than 00:21:00, less than 00:40:00 = 3088
6	6/2/2021 10:57	6/2/2021 11:01	SARH_Physicians_CSQ	Physicians_CSQ*	0:00:02	Traci Mizer	0:03:36
7	6/2/2021 14:27	6/2/2021 14:34	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:02	Ingrid Claros	0:04:19
8	6/9/2021 10:46	6/9/2021 11:14	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:02	Sylvia Rios	0:14:37
9	6/11/2021 10:47	6/11/2021 10:55	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:02	Ingrid Claros	0:05:00
10	6/11/2021 15:46	6/11/2021 15:59	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:02	Sylvia Rios	0:10:54
11	6/11/2021 16:12	6/11/2021 16:21	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:02	Gloria Gutierrez Herrera	0:08:14
12	6/14/2021 11:16	6/14/2021 11:19	SARH_Scheduling_CSQ	Pre_Registration_CSQ*	0:00:02	Sylvia Rios	0:02:11
13	6/14/2021 11:25	6/14/2021 11:26	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:02	Sylvia Rios	0:00:44
14	6/14/2021 12:30	6/14/2021 12:39	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:02	Gloria Gutierrez Herrera	0:08:30
15	6/14/2021 15:34	6/14/2021 15:42	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:02	Sylvia Rios	0:05:09
16	6/16/2021 9:44	6/16/2021 9:52	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:02	Sylvia Rios	0:06:07
17	6/16/2021 10:12	6/16/2021 10:15	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:02	Sylvia Rios	0:02:34
18	6/16/2021 12:43	6/16/2021 13:00	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:02	Ingrid Claros	0:11:55
19	6/16/2021 16:36	6/16/2021 16:38	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:02	Traci Mizer	0:00:26
20	6/16/2021 16:39	6/16/2021 16:48	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:02	Traci Mizer	0:07:58
21	6/17/2021 11:43	6/17/2021 11:53	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:02	Sylvia Rios	0:06:45
22	6/17/2021 14:34	6/17/2021 14:35	SARH_Scheduling_CSQ	Pre_Registration_CSQ*	0:00:02	Sylvia Rios	0:00:21
23	6/17/2021 14:35	6/17/2021 14:44	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:02	Sylvia Rios	0:05:13
24	6/18/2021 9:14	6/18/2021 9:15	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:02	Ingrid Claros	0:00:40
25	6/18/2021 9:15	6/18/2021 9:30	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:02	Sylvia Rios	0:07:46
26	6/18/2021 10:41	6/18/2021 10:59	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:02	Sylvia Rios	0:09:18
27	6/18/2021 15:52	6/18/2021 16:04	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:02	Ingrid Claros	0:09:27
28	6/18/2021 15:55	6/18/2021 15:58	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:02	Sylvia Rios	0:02:55
29	6/21/2021 10:29	6/21/2021 10:55	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:02	Sylvia Rios	0:19:44
30	6/21/2021 11:15	6/21/2021 11:16	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:02	Gloria Gutierrez Herrera	0:00:55
31	6/21/2021 13:19	6/21/2021 13:24	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:02	Sylvia Rios	0:03:55
32	6/21/2021 13:40	6/21/2021 13:54	SARH_Scheduling_CSQ	Pre_Registration_CSQ*	0:00:02	Sylvia Rios	0:14:38
33	6/22/2021 9:13	6/22/2021 9:23	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:02	Gloria Gutierrez Herrera	0:09:28
34	6/22/2021 10:23	6/22/2021 10:23	SARH_Scheduling_CSQ	Mammography_CSQ	0:00:02	Sylvia Rios	0:00:00
35	6/22/2021 15:38	6/22/2021 15:40	SARH_Physicians_CSQ	Physicians_CSQ*	0:00:02	Gloria Gutierrez Herrera	0:01:23
36	6/23/2021 9:29	6/23/2021 9:29	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:02	Ingrid Claros	0:00:01
37	6/23/2021 9:42	6/23/2021 9:53	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:02	Sylvia Rios	0:08:10
38	6/23/2021 10:47	6/23/2021 11:00	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:02	Sylvia Rios	0:10:16
39	6/23/2021 14:59	6/23/2021 15:07	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:02	Sylvia Rios	0:05:46
40	6/23/2021 15:52	6/23/2021 16:05	SARH_Scheduling_CSQ	Pre_Registration_CSQ*	0:00:02	Sylvia Rios	0:11:05
41	6/23/2021 16:07	6/23/2021 16:15	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:02	Gloria Gutierrez Herrera	0:07:46
42	6/24/2021 8:52	6/24/2021 8:55	SARH_Scheduling_CSQ	Pre_Registration_CSQ*	0:00:02	Sylvia Rios	0:03:05
43	6/24/2021 9:25	6/24/2021 9:25	SARH_Scheduling_CSQ	Pre_Registration_CSQ*	0:00:02	Sylvia Rios	0:00:07
44	6/24/2021 10:35	6/24/2021 10:35	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:02	Ingrid Claros	0:00:20
45	6/24/2021 11:13	6/24/2021 11:24	SARH_Scheduling_CSQ	Pre_Registration_CSQ*	0:00:02	Sylvia Rios	0:07:05
46	6/24/2021 11:18	6/24/2021 11:26	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:02	Traci Mizer	0:07:27
47	6/25/2021 9:16	6/25/2021 9:25	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:02	Sylvia Rios	0:05:28
48	6/25/2021 9:25	6/25/2021 9:29	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:02	Ingrid Claros	0:02:11
49	6/25/2021 10:08	6/25/2021 10:15	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:02	Sylvia Rios	0:05:29
50	6/25/2021 11:52	6/25/2021 12:00	SARH_Scheduling_CSQ	Pre_Registration_CSQ*	0:00:02	Sylvia Rios	0:04:17
51	6/25/2021 14:44	6/25/2021 14:50	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:02	Sylvia Rios	0:03:18
52	6/28/2021 9:30	6/28/2021 9:34	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:02	Sylvia Rios	0:03:10
53	6/28/2021 13:37	6/28/2021 13:39	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:02	Sylvia Rios	0:01:28
54	6/29/2021 9:29	6/29/2021 9:31	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:02	Ingrid Claros	0:02:24
55	6/29/2021 11:55	6/29/2021 11:56	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:02	Ingrid Claros	0:00:38
56	6/29/2021 13:45	6/29/2021 13:47	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:02	Ingrid Claros	0:00:42
57	6/29/2021 16:51	6/29/2021 16:59	SARH_Scheduling_CSQ	Pre_Registration_CSQ*	0:00:02	Gloria Gutierrez Herrera	0:08:46
58	6/30/2021 11:20	6/30/2021 11:33	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:02	Traci Mizer	0:12:38
59	6/30/2021 12:31	6/30/2021 12:42	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:02	Traci Mizer	0:05:13
60	6/30/2021 15:36	6/30/2021 15:39	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:02	Ingrid Claros	0:03:22
61	6/30/2021 15:45	6/30/2021 15:53	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:02	Sylvia Rios	0:05:41
62	6/3/2021 10:23	6/3/2021 10:36	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:03	Cynthia Schuster	0:10:04
63	6/3/2021 12:28	6/3/2021 12:30	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:03	Traci Mizer	0:00:46
64	6/4/2021 14:09	6/4/2021 14:17	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:03	Ingrid Claros	0:04:42
65	6/9/2021 10:38	6/9/2021 10:45	SARH_Scheduling_CSQ	Pre_Registration_CSQ*	0:00:03	Sylvia Rios	0:05:05
66	6/9/2021 14:18	6/9/2021 14:25	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:03	Sylvia Rios	0:05:09
67	6/10/2021 9:18	6/10/2021 9:25	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:03	Sylvia Rios	0:05:45
68	6/10/2021 11:08	6/10/2021 11:09	SARH_Scheduling_CSQ	Pre_Registration_CSQ*	0:00:03	Sylvia Rios	0:00:19
69	6/11/2021 9:12	6/11/2021 9:14	SARH_Scheduling_CSQ	Pre_Registration_CSQ*	0:00:03	Ingrid Claros	0:02:22
70	6/11/2021 10:44	6/11/2021 10:56	SARH_Scheduling_CSQ	Pre_Registration_CSQ*	0:00:03	Sylvia Rios	0:09:22
71	6/11/2021 15:02	6/11/2021 15:05	SARH_Scheduling_CSQ	Pre_Registration_CSQ*	0:00:03	Sylvia Rios	0:02:22
72	6/11/2021 15:10	6/11/2021 15:13	SARH_Scheduling_CSQ	Pre_Registration_CSQ*	0:00:03	Sylvia Rios	0:00:57
73	6/14/2021 9:01	6/14/2021 9:03	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:03	Sylvia Rios	0:01:31
74	6/14/2021 9:12	6/14/2021 9:30	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:03	Sylvia Rios	0:14:15
75	6/14/2021 10:50	6/14/2021 10:56	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:03	Sylvia Rios	0:02:42
76	6/14/2021 13:58	6/14/2021 14:16	SARH_Scheduling_CSQ	Mammography_CSQ*	0:00:03	Sylvia Rios	0:13:30
77	6/15/2021 16:05	6/15/2021 16:06	SARH_Scheduling_CSQ	Radiology_CSQ*	0:00:03	Gloria Gutierrez Herrera	0:00:59
RSA Wait Time_Agent handled

Cell Formulas
Range	Formula
H4	H4	=COUNT(E2:E4000,"<0:21:00")
H5	H5	=COUNT(E2:E4000,"<0:21:00, >0:41:00")

 

[igold]

This for cell H5

=COUNTIFS(E2:E4000,">0:21:00",E2:E4000,"<0:41:00")

 

[mr_ITtoyou]

This for cell H5

=COUNTIFS(E2:E4000,">0:21:00",E2:E4000,"<0:41:00")

igold, that worked great. Thanks again for your help.

 

[igold]

You are welcome. I am glad you finally got it squared away.