Formula for Counting Calls between a date range - Countif with multiple columns

[jeells102_digitickets]

Hi all, I'm sure I'm doing something really silly with my formula however, I've basically got a table of total number of calls made per day. In column A I have the date, and in Column B I have the call number. I'm trying to calculate the total of the calls, made within a date range specified on another sheet in a different cell. The start and end dates are in seperate cells.

=COUNTIFS('Detailed List'!B3:B367, ">=" &'Dashboard By Week'!C3,'Detailed List'!B3:B367,"<=" &'Dashboard By Week'!D3,'Detailed List'!C3:C367,)

That is my forumla, however it's not calculating the sum correctly, only giving a value of 3 or 7 so I think it's not calculating it correctly but I can't see where. Any ideas would be appreciated.

 

[jeells102_digitickets]

2022 Metrics Tracker.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M			P	Q
1	January 2022
2
3			1/1/22	1/7/22
4
5	Week 1	Andrew MacKinder	Jacob Eells	Sarah Ellis	Sarah Walsh	Gayle Robson	Total
6	Total Inbound Calls	3	0	0	0	0	3
7	Total Outbound Calls	93	14	69	81	0	257
8	Total New Cases	25	22	37	53	0	137
9	Total Resolved Cases	23	25	27	49	0	124
10	Total Intercom	24	10	54	80	0	168
11	Average Resolution Time	11.52	64.04	10.41	24.10	0	27.52 Days
12	Total Missed Calls	88
13
14
15
16											Month Leaderboard					Support KPIs
17	New vs Resolved Cases	13									Most Inbound Calls	Andrew MacKinder				Answered Calls	90%
18	Total Inbound Calls	91									Most Outbound Calls	Andrew MacKinder				Missed Calls	10%
19	Total Calls on Weekend	34									Most New Cases	Sarah Walsh				First Response	4 Hours
20	Total Calls on Weekdays	236									Most Resolved Cases	Sarah Walsh				Average Resolution	7 Days
21	Percentage of Answered Calls	3%									Most Intercom Chats	Sarah Walsh
22	Percentage of Missed Calls	97%
23	Percetange of Outbound vs Inbound Calls	282%
24
25
26
Dashboard By Week

Cell Formulas
Range	Formula
C3	C3	=VLOOKUP($A$5,$AD$1:$AF$53,2,FALSE)
D3	D3	=VLOOKUP($A$5,$AD$1:$AF$53,3,FALSE)
B6	B6	=COUNTIFS('Detailed List'!B3:B367, ">=" &'Dashboard By Week'!C3,'Detailed List'!B3:B367,"<=" &'Dashboard By Week'!D3,'Detailed List'!C3:C367,)
C6	C6	=COUNTIFS('Detailed List'!I3:I367, ">=" &'Dashboard By Week'!D3,'Detailed List'!I3:I367,"<=" &'Dashboard By Week'!E3)
D6:F6	D6	=COUNTIFS('Detailed List'!D3:E367, ">=" &'Dashboard By Week'!E3,'Detailed List'!D3:E367,"<=" &'Dashboard By Week'!F3)
G6:G10	G6	=SUM(B6:F6)
B7	B7	=SUMIFS('Detailed List'!D3:D367,'Detailed List'!B3:B367, ">=" & 'Dashboard By Week'!A1,'Detailed List'!B3:B367, "<=" & EOMONTH(A1,1))
C7	C7	=SUMIFS('Detailed List'!J3:J367,'Detailed List'!B3:B367, ">=" & 'Dashboard By Week'!A1,'Detailed List'!B3:B367, "<=" & EOMONTH(A1,1))
D7	D7	=SUMIFS('Detailed List'!P3:P367,'Detailed List'!B3:B367, ">=" & 'Dashboard By Week'!A1,'Detailed List'!B3:B367, "<=" & EOMONTH(A1,1))
E7	E7	=SUMIFS('Detailed List'!V3:V367,'Detailed List'!B3:B367, ">=" & 'Dashboard By Week'!A1,'Detailed List'!B3:B367, "<=" & EOMONTH(A1,1))
F7	F7	=SUMIFS('Detailed List'!AB$3:AB$367,'Detailed List'!$B$3:$B$367, ">=" & 'Dashboard By Week'!$A$1,'Detailed List'!$B$3:$B$367, "<=" & EOMONTH($A$1,1))
B8	B8	=SUMIFS('Detailed List'!G3:G367,'Detailed List'!B3:B367, ">=" & 'Dashboard By Week'!A1,'Detailed List'!B3:B367, "<=" & EOMONTH(A1,1))
C8	C8	=SUMIFS('Detailed List'!M3:M367,'Detailed List'!B3:B367, ">=" & 'Dashboard By Week'!A1,'Detailed List'!B3:B367, "<=" & EOMONTH(A1,1))
D8	D8	=SUMIFS('Detailed List'!S3:S367,'Detailed List'!B3:B367, ">=" & 'Dashboard By Week'!A1,'Detailed List'!B3:B367, "<=" & EOMONTH(A1,1))
E8	E8	=SUMIFS('Detailed List'!Y3:Y367,'Detailed List'!B3:B367, ">=" & 'Dashboard By Week'!A1,'Detailed List'!B3:B367, "<=" & EOMONTH(A1,1))
F8	F8	=SUMIFS('Detailed List'!AE$3:AE$367,'Detailed List'!$B$3:$B$367, ">=" & 'Dashboard By Week'!$A$1,'Detailed List'!$B$3:$B$367, "<=" & EOMONTH($A$1,1))
B9	B9	=SUMIFS('Detailed List'!H3:H367,'Detailed List'!B3:B367, ">=" & 'Dashboard By Week'!A1,'Detailed List'!B3:B367, "<=" & EOMONTH(A1,1))
C9	C9	=SUMIFS('Detailed List'!N3:N367,'Detailed List'!B3:B367, ">=" & 'Dashboard By Week'!A1,'Detailed List'!B3:B367, "<=" & EOMONTH(A1,1))
D9	D9	=SUMIFS('Detailed List'!T3:T367,'Detailed List'!B3:B367, ">=" & 'Dashboard By Week'!A1,'Detailed List'!B3:B367, "<=" & EOMONTH(A1,1))
E9	E9	=SUMIFS('Detailed List'!Z3:Z367,'Detailed List'!B3:B367, ">=" & 'Dashboard By Week'!A1,'Detailed List'!B3:B367, "<=" & EOMONTH(A1,1))
F9	F9	=SUMIFS('Detailed List'!AF$3:AF$367,'Detailed List'!$B$3:$B$367, ">=" & 'Dashboard By Week'!$A$1,'Detailed List'!$B$3:$B$367, "<=" & EOMONTH($A$1,1))
B10	B10	=SUMIFS('Detailed List'!F3:F367,'Detailed List'!B3:B367, ">=" & 'Dashboard By Week'!A1,'Detailed List'!B3:B367, "<=" & EOMONTH(A1,1))
C10	C10	=SUMIFS('Detailed List'!L3:L367,'Detailed List'!B3:B367, ">=" & 'Dashboard By Week'!A1,'Detailed List'!B3:B367, "<=" & EOMONTH(A1,1))
D10	D10	=SUMIFS('Detailed List'!R3:R367,'Detailed List'!B3:B367, ">=" & 'Dashboard By Week'!A1,'Detailed List'!B3:B367, "<=" & EOMONTH(A1,1))
E10	E10	=SUMIFS('Detailed List'!X3:X367,'Detailed List'!B3:B367, ">=" & 'Dashboard By Week'!A1,'Detailed List'!B3:B367, "<=" & EOMONTH(A1,1))
F10	F10	=SUMIFS('Detailed List'!AD$3:AD$367,'Detailed List'!$B$3:$B$367, ">=" & 'Dashboard By Week'!$A$1,'Detailed List'!$B$3:$B$367, "<=" & EOMONTH($A$1,1))
B11	B11	=IFERROR(AVERAGEIFS('Resolved Cases'!P2:P1048576,'Resolved Cases'!A2:A1048576,B5,'Resolved Cases'!L2:L1048576,">="&A1,'Resolved Cases'!L2:L1048576,"<="&EOMONTH(A1,1)),"0")
C11:F11	C11	=IFERROR(AVERAGEIFS('Resolved Cases'!$P$2:$P$1048576,'Resolved Cases'!$A$2:$A$1048576,C5,'Resolved Cases'!$L$2:$L$1048576,">="&$A$1,'Resolved Cases'!$L$2:$L$1048576,"<="&EOMONTH($A$1,1)),"0")
G11	G11	=AVERAGE(B11:F11)
B12	B12	=SUMIFS('Detailed List'!E3:E367,'Detailed List'!B3:B367, ">=" & 'Dashboard By Week'!A1,'Detailed List'!B3:B367, "<=" & EOMONTH(A1,1))
L17	L17	=INDEX(B5:F5,MATCH(MAX(B6:F6),B6:E6,0))
L18	L18	=INDEX(B5:F5,MATCH(MAX(B7:F7),B7:E7,0))
L19	L19	=INDEX(B5:F5,MATCH(MAX(B8:F8),B8:E8,0))
L20	L20	=INDEX(B5:F5,MATCH(MAX(B9:F9),B9:E9,0))
L21	L21	=INDEX(B5:F5,MATCH(MAX(B10:F10),B10:E10,0))
B17	B17	=$G$8-$G$9
B18	B18	=$G$6+$B$12
B19	B19	=SUM($N$3:$N$6)
B20	B20	=SUM($O$3:$O$6)
B21	B21	=$G$6/$B$18
B22	B22	=$B$12/$B$18
B23	B23	=G7/B18

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G11	Cell Value	<6	text	NO
G11	Cell Value	>7	text	NO
B21	Cell Value	<0.89	text	NO
B21	Cell Value	>0.9	text	NO
B22	Cell Value	>0.11	text	NO
B22	Cell Value	<0.1	text	NO
B17	Cell Value	>0	text	NO
B17	Cell Value	<0	text	NO

Cells with Data Validation
Cell	Allow	Criteria
K25:Q26	Any value
L1:Q14	Any value
K1:K15	Any value
A1:G2	List	=months
H:J	Any value
A3:A4	Any value
B3:G1048576	Any value
A5	List	=$AD$2:$AD$53
A6:A1048576	Any value