Sum((CountIF, with Mult. Ranges across Mult. Tabs, 1 Criteria) + (CountIF, with Mult. Ranges across Mult. Tabs, 1 Criteria))

[AudyAnalyst]

Hello,

I'm trying to attempt to put into one table both the age group the pet is in and the groups they scored into. I'm struggling with getting the two different tabs to calculate one number and the age being ">=" and "<=". Excel keeps saying I have too many arguments.

Any Help Would Be great!

Example Date- Simple Master.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	Age	Global	DE	US				Score	DE	US
2	Less than 1 Year	9	1	8.00				No Need	1	6
3	1 Year	13	3.00	10.00				1	1	1
4	2 Years	2	1.00	1.00				1.5	1	1
5	3 Years	2	0.00	2.00				2	0	1
6	4 Years	2	1.00	1.00				2.5	1	1
7	5 Years	4	1.00	3.00				3	2	3
8	6 Years	3	2.00	1.00				3.5	3	4
9	7 Years	12	4.00	8.00				4	1	10
10	8 Years	0	0.00	0.00				4.5	1	1
11	9 Years	0	0.00	0.00				5	2	6
12	Total	47.00	13.00	34.00				Total	13	34
13
14
15	Age	No Need	1	1.5	2	2.5	3	3.5	4	4.5	5
16	Less than 1 Year
17	1 Year
18	2 Years
19	3 Years
20	4 Years
21	5 Years
22	6 Years
23	7 Years
24	8 Years
25	9 Years
LOS

Cell Formulas
Range	Formula
B2:B11	B2	=SUM(C2:D2)
C2	C2	=COUNTIF(DE!$D:$D,"<=0.99")
D2	D2	=COUNTIF(US!$C:$C,"<=0.99")
C3	C3	=COUNTIFS(DE!$D:$D,">=1.0",DE!$D:$D,"<=1.99")
D3	D3	=COUNTIFS(US!$C:$C,">=1.0",US!$C:$C,"<=1.99")
C4	C4	=COUNTIFS(DE!$D:$D,">=2.0",DE!$D:$D,"<=2.99")
D4	D4	=COUNTIFS(US!$C:$C,">=2.0",US!$C:$C,"<=2.99")
C5	C5	=COUNTIFS(DE!$D:$D,">=3.0",DE!$D:$D,"<=3.99")
D5	D5	=COUNTIFS(US!$C:$C,">=3.0",US!$C:$C,"<=3.99")
C6	C6	=COUNTIFS(DE!$D:$D,">=4.0",DE!$D:$D,"<=4.99")
D6	D6	=COUNTIFS(US!$C:$C,">=4.0",US!$C:$C,"<=4.99")
C7	C7	=COUNTIFS(DE!$D:$D,">=5.0",DE!$D:$D,"<=5.99")
D7	D7	=COUNTIFS(US!$C:$C,">=5.0",US!$C:$C,"<=5.99")
C8	C8	=COUNTIFS(DE!$D:$D,">=6.0",DE!$D:$D,"<=6.99")
D8	D8	=COUNTIFS(US!$C:$C,">=6.0",US!$C:$C,"<=6.99")
C9	C9	=COUNTIFS(DE!$D:$D,">=7.0",DE!$D:$D,"<=7.99")
D9	D9	=COUNTIFS(US!$C:$C,">=7.0",US!$C:$C,"<=7.99")
C10	C10	=COUNTIFS(DE!$D:$D,">=8.0",DE!$D:$D,"<=8.99")
D10	D10	=COUNTIFS(US!$C:$C,">=8.0",US!$C:$C,"<=8.99")
C11	C11	=COUNTIFS(DE!$D:$D,">=9.0",DE!$D:$D,"<=9.99")
D11	D11	=COUNTIFS(US!$C:$C,">=9.0",US!$C:$C,"<=9.99")
B12	B12	=SUBTOTAL(109,[Global])
C12,I12	C12	=SUBTOTAL(109,[DE])
D12,J12	D12	=SUBTOTAL(109,[US])
I2:I11	I2	=COUNTIF(DE!$F:$F,H2)
J2:J11	J2	=COUNTIF(US!$E:$E,H2)

Example Date- Simple Master.xlsx
	A	B	C	D	E
1	Pet Name	Birthday	Age	Event Date	Score
2	Button	3/1/2022	0.00	3/1/2022	No Need
3	Bear	7/13/2020	1.63	3/1/2022	5.00
4	Bullet	7/1/2020	1.67	3/1/2022	2.50
5	Max	6/1/2020	1.75	3/1/2022	3.00
6	Charlie	2/1/2020	2.08	3/1/2022	3.50
7	Cooper	4/1/2017	4.92	3/1/2022	5.00
8	Buddy	3/1/2017	5.00	3/1/2022	1.00
9	Rocky	7/1/2015	6.67	3/1/2022	1.50
10	Milo	5/5/2015	6.82	3/1/2022	4.50
11	Jack	1/12/2015	7.14	3/1/2022	3.00
12	Luna.	1/1/2015	7.17	3/1/2022	4.00
13	Lucy.	12/1/2014	7.25	3/1/2022	3.50
14	Rocket	11/1/2014	7.33	3/1/2022	3.50
DE

Example Date- Simple Master.xlsx
	A	B	C	D	E
1	Pet Name	Birthday	Age	Event Date	Score
2	Harvey	2/21/2022	0.03	3/1/2022	No Need
3	Sasha	2/14/2022	0.05	3/1/2022	No Need
4	Cookie	1/24/2022	0.10	3/1/2022	No Need
5	Scout	1/24/2022	0.10	3/1/2022	No Need
6	Dexter	12/6/2021	0.24	3/1/2022	1.50
7	Bruno	11/29/2021	0.26	3/1/2022	No Need
8	Zoe	11/29/2021	0.26	3/1/2022	No Need
9	Louis	7/6/2021	0.65	3/1/2022	2.00
10	Billie	1/4/2021	1.16	3/1/2022	2.50
11	Lexi	12/14/2020	1.21	3/1/2022	5.00
12	Charlie	12/14/2020	1.21	3/1/2022	4.50
13	Koda	11/30/2020	1.25	3/1/2022	4.00
14	Pippa	10/31/2020	1.34	3/1/2022	3.00
15	Duke	9/21/2020	1.44	3/1/2022	5.00
16	Bruce	8/24/2020	1.52	3/1/2022	4.00
17	Oreo	5/26/2020	1.76	3/1/2022	5.00
18	Rusty	5/18/2020	1.79	3/1/2022	4.00
19	Baxter	5/4/2020	1.83	3/1/2022	4.00
20	Gus	7/29/2019	2.59	3/1/2022	3.00
21	Milly	9/17/2018	3.46	3/1/2022	3.50
22	Ellie	5/29/2018	3.76	3/1/2022	4.00
23	Jessie	8/1/2017	4.58	3/1/2022	4.00
24	Stella	11/21/2016	5.28	3/1/2022	5.00
25	Diesel	4/11/2016	5.89	3/1/2022	1.00
26	Cleo	3/28/2016	5.93	3/1/2022	3.50
27	Evie	7/27/2015	6.59	3/1/2022	3.50
28	Winnie	11/17/2014	7.29	3/1/2022	3.50
29	Bella.	10/1/2014	7.42	3/1/2022	4.00
30	Luna.	9/3/2014	7.49	3/1/2022	4.00
31	Lucy.	9/2/2014	7.50	3/1/2022	5.00
32	Daisy.	8/25/2014	7.52	3/1/2022	4.00
33	Lily.	8/18/2014	7.54	3/1/2022	4.00
34	Zoe.	8/4/2014	7.58	3/1/2022	3.00
35	Lola.	6/23/2014	7.69	3/1/2022	5.00
US

Here is the Data raw if that is helpful:

Pet Name	Birthday	Age	Event Date	Score
Harvey​	2/21/2022​	0.03​	3/1/2022​	No Need​
Sasha​	2/14/2022​	0.05​	3/1/2022​	No Need​
Cookie​	1/24/2022​	0.10​	3/1/2022​	No Need​
Scout​	1/24/2022​	0.10​	3/1/2022​	No Need​
Dexter​	12/6/2021​	0.24​	3/1/2022​	1.50​
Bruno​	11/29/2021​	0.26​	3/1/2022​	No Need​
Zoe​	11/29/2021​	0.26​	3/1/2022​	No Need​
Louis​	7/6/2021​	0.65​	3/1/2022​	2.00​
Billie​	1/4/2021​	1.16​	3/1/2022​	2.50​
Lexi​	12/14/2020​	1.21​	3/1/2022​	5.00​
Charlie​	12/14/2020​	1.21​	3/1/2022​	4.50​
Koda​	11/30/2020​	1.25​	3/1/2022​	4.00​
Pippa​	10/31/2020​	1.34​	3/1/2022​	3.00​
Duke​	9/21/2020​	1.44​	3/1/2022​	5.00​
Bruce​	8/24/2020​	1.52​	3/1/2022​	4.00​
Oreo​	5/26/2020​	1.76​	3/1/2022​	5.00​
Rusty​	5/18/2020​	1.79​	3/1/2022​	4.00​
Baxter​	5/4/2020​	1.83​	3/1/2022​	4.00​
Gus​	7/29/2019​	2.59​	3/1/2022​	3.00​
Milly​	9/17/2018​	3.46​	3/1/2022​	3.50​
Ellie​	5/29/2018​	3.76​	3/1/2022​	4.00​
Jessie​	8/1/2017​	4.58​	3/1/2022​	4.00​
Stella​	11/21/2016​	5.28​	3/1/2022​	5.00​
Diesel​	4/11/2016​	5.89​	3/1/2022​	1.00​
Cleo​	3/28/2016​	5.93​	3/1/2022​	3.50​
Evie​	7/27/2015​	6.59​	3/1/2022​	3.50​
Winnie​	11/17/2014​	7.29​	3/1/2022​	3.50​
Bella.​	10/1/2014​	7.42​	3/1/2022​	4.00​
Luna.​	9/3/2014​	7.49​	3/1/2022​	4.00​
Lucy.​	9/2/2014​	7.50​	3/1/2022​	5.00​
Daisy.​	8/25/2014​	7.52​	3/1/2022​	4.00​
Lily.​	8/18/2014​	7.54​	3/1/2022​	4.00​
Zoe.​	8/4/2014​	7.58​	3/1/2022​	3.00​
Lola.​	6/23/2014​	7.69​	3/1/2022​	5.00​

Pet Name	Birthday	Age	Event Date	Score
Button​	3/1/2022​	0.00​	3/1/2022​	No Need​
Bear​	7/13/2020​	1.63​	3/1/2022​	5.00​
Bullet​	7/1/2020​	1.67​	3/1/2022​	2.50​
Max​	6/1/2020​	1.75​	3/1/2022​	3.00​
Charlie​	2/1/2020​	2.08​	3/1/2022​	3.50​
Cooper​	4/1/2017​	4.92​	3/1/2022​	5.00​
Buddy​	3/1/2017​	5.00​	3/1/2022​	1.00​
Rocky​	7/1/2015​	6.67​	3/1/2022​	1.50​
Milo​	5/5/2015​	6.82​	3/1/2022​	4.50​
Jack​	1/12/2015​	7.14​	3/1/2022​	3.00​
Luna.​	1/1/2015​	7.17​	3/1/2022​	4.00​
Lucy.​	12/1/2014​	7.25​	3/1/2022​	3.50​
Rocket​	11/1/2014​	7.33​	3/1/2022​	3.50​

 

[ExceLoki]

this will work if you have a raw data sheet. i added totals to the bottom table to verify all the numbers matched the top tables

----------------

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	Age	Global	DE	US				Score	Global	DE	US
2	Less than 1 Year	9	1	8				No Need	7	1	6
3	1 Year	13	3	10				1	2	1	1
4	2 Years	2	1	1				1.5	2	1	1
5	3 Years	2	0	2				2	1	0	1
6	4 Years	2	1	1				2.5	2	1	1
7	5 Years	4	1	3				3	5	2	3
8	6 Years	3	2	1				3.5	7	3	4
9	7 Years	12	4	8				4	11	1	10
10	8 Years	0	0	0				4.5	2	1	1
11	9 Years	0	0	0				5	8	2	6
12	Total	47	13	34				Total	47	13	34
13
14
15	Age	No Need	1	1.5	2	2.5	3	3.5	4	4.5	5	Total
16	Less than 1 Year	7	0	1	1	0	0	0	0	0	0	9
17	1 Year	0	0	0	0	2	2	0	4	1	4	13
18	2 Years	0	0	0	0	0	1	1	0	0	0	2
19	3 Years	0	0	0	0	0	0	1	1	0	0	2
20	4 Years	0	0	0	0	0	0	0	1	0	1	2
21	5 Years	0	2	0	0	0	0	1	0	0	1	4
22	6 Years	0	0	1	0	0	0	1	0	1	0	3
23	7 Years	0	0	0	0	0	2	3	5	0	2	12
24	8 Years	0	0	0	0	0	0	0	0	0	0	0
25	9 Years	0	0	0	0	0	0	0	0	0	0	0
26	Total	7	2	2	1	2	5	7	11	2	8	47
LOS

Cell Formulas
Range	Formula
B2:B11,I2:I11	B2	=SUM(C2:D2)
C2	C2	=COUNTIF(DE!$D:$D,"<=0.99")
D2	D2	=COUNTIF(US!$C:$C,"<=0.99")
C3	C3	=COUNTIFS(DE!$D:$D,">=1.0",DE!$D:$D,"<=1.99")
D3	D3	=COUNTIFS(US!$C:$C,">=1.0",US!$C:$C,"<=1.99")
C4	C4	=COUNTIFS(DE!$D:$D,">=2.0",DE!$D:$D,"<=2.99")
D4	D4	=COUNTIFS(US!$C:$C,">=2.0",US!$C:$C,"<=2.99")
C5	C5	=COUNTIFS(DE!$D:$D,">=3.0",DE!$D:$D,"<=3.99")
D5	D5	=COUNTIFS(US!$C:$C,">=3.0",US!$C:$C,"<=3.99")
C6	C6	=COUNTIFS(DE!$D:$D,">=4.0",DE!$D:$D,"<=4.99")
D6	D6	=COUNTIFS(US!$C:$C,">=4.0",US!$C:$C,"<=4.99")
C7	C7	=COUNTIFS(DE!$D:$D,">=5.0",DE!$D:$D,"<=5.99")
D7	D7	=COUNTIFS(US!$C:$C,">=5.0",US!$C:$C,"<=5.99")
C8	C8	=COUNTIFS(DE!$D:$D,">=6.0",DE!$D:$D,"<=6.99")
D8	D8	=COUNTIFS(US!$C:$C,">=6.0",US!$C:$C,"<=6.99")
C9	C9	=COUNTIFS(DE!$D:$D,">=7.0",DE!$D:$D,"<=7.99")
D9	D9	=COUNTIFS(US!$C:$C,">=7.0",US!$C:$C,"<=7.99")
C10	C10	=COUNTIFS(DE!$D:$D,">=8.0",DE!$D:$D,"<=8.99")
D10	D10	=COUNTIFS(US!$C:$C,">=8.0",US!$C:$C,"<=8.99")
C11	C11	=COUNTIFS(DE!$D:$D,">=9.0",DE!$D:$D,"<=9.99")
D11	D11	=COUNTIFS(US!$C:$C,">=9.0",US!$C:$C,"<=9.99")
B12:D12,I12:K12	B12	=SUBTOTAL(109,B2:B11)
J2:J11	J2	=COUNTIF(DE!$F:$F,H2)
K2:K11	K2	=COUNTIF(US!$E:$E,H2)
B16:K16	B16	=COUNTIFS(RawData!$E:$E,LOS!B15,RawData!$C:$C,"<=0.99")
L16:L25	L16	=SUM(B16:K16)
B17:K17	B17	=COUNTIFS(RawData!$E:$E,LOS!B15,RawData!$C:$C,">=1.0",RawData!$C:$C,"<=1.99")
B18:K18	B18	=COUNTIFS(RawData!$E:$E,LOS!B15,RawData!$C:$C,">=2.0",RawData!$C:$C,"<=2.99")
B19:K19	B19	=COUNTIFS(RawData!$E:$E,LOS!B15,RawData!$C:$C,">=3.0",RawData!$C:$C,"<=3.99")
B20:K20	B20	=COUNTIFS(RawData!$E:$E,LOS!B15,RawData!$C:$C,">=4.0",RawData!$C:$C,"<=4.99")
B21:K21	B21	=COUNTIFS(RawData!$E:$E,LOS!B15,RawData!$C:$C,">=5.0",RawData!$C:$C,"<=5.99")
B22:K22	B22	=COUNTIFS(RawData!$E:$E,LOS!B15,RawData!$C:$C,">=6.0",RawData!$C:$C,"<=6.99")
B23:K23	B23	=COUNTIFS(RawData!$E:$E,LOS!B15,RawData!$C:$C,">=7.0",RawData!$C:$C,"<=7.99")
B24:K24	B24	=COUNTIFS(RawData!$E:$E,LOS!B15,RawData!$C:$C,">=8.0",RawData!$C:$C,"<=8.99")
B25:K25	B25	=COUNTIFS(RawData!$E:$E,LOS!B15,RawData!$C:$C,">=9.0",RawData!$C:$C,"<=9.99")
B26:L26	B26	=SUM(B16:B25)

 

[ExceLoki]

if you dont have a raw data sheet, this should work
------------------

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
15	Age	No Need	1	1.5	2	2.5	3	3.5	4	4.5	5	Total
16	Less than 1 Year	7	0	1	1	0	0	0	0	0	0	9
17	1 Year	0	0	0	0	2	2	0	4	1	4	13
18	2 Years	0	0	0	0	0	1	1	0	0	0	2
19	3 Years	0	0	0	0	0	0	1	1	0	0	2
20	4 Years	0	0	0	0	0	0	0	1	0	1	2
21	5 Years	0	2	0	0	0	0	1	0	0	1	4
22	6 Years	0	0	1	0	0	0	1	0	1	0	3
23	7 Years	0	0	0	0	0	2	3	5	0	2	12
24	8 Years	0	0	0	0	0	0	0	0	0	0	0
25	9 Years	0	0	0	0	0	0	0	0	0	0	0
26	Total	7	2	2	1	2	5	7	11	2	8	47
LOS (2)

Cell Formulas
Range	Formula
B16:K16	B16	=COUNTIFS(DE!$F:$F,'LOS (2)'!B15,DE!$D:$D,"<=0.99")+COUNTIFS(US!$E:$E,'LOS (2)'!B15,US!$C:$C,"<=0.99")
L16:L25	L16	=SUM(B16:K16)
B17:K17	B17	=COUNTIFS(DE!$F:$F,'LOS (2)'!B15,DE!$D:$D,">=1.0",DE!$D:$D,"<=1.99")+COUNTIFS(US!$E:$E,'LOS (2)'!B15,US!$C:$C,">=1.0",US!$C:$C,"<=1.99")
B18:K18	B18	=COUNTIFS(DE!$F:$F,'LOS (2)'!B15,DE!$D:$D,">=2.0",DE!$D:$D,"<=2.99")+COUNTIFS(US!$E:$E,'LOS (2)'!B15,US!$C:$C,">=2.0",US!$C:$C,"<=2.99")
B19:K19	B19	=COUNTIFS(DE!$F:$F,'LOS (2)'!B15,DE!$D:$D,">=3.0",DE!$D:$D,"<=3.99")+COUNTIFS(US!$E:$E,'LOS (2)'!B15,US!$C:$C,">=3.0",US!$C:$C,"<=3.99")
B20:K20	B20	=COUNTIFS(DE!$F:$F,'LOS (2)'!B15,DE!$D:$D,">=4.0",DE!$D:$D,"<=4.99")+COUNTIFS(US!$E:$E,'LOS (2)'!B15,US!$C:$C,">=4.0",US!$C:$C,"<=4.99")
B21:K21	B21	=COUNTIFS(DE!$F:$F,'LOS (2)'!B15,DE!$D:$D,">=5.0",DE!$D:$D,"<=5.99")+COUNTIFS(US!$E:$E,'LOS (2)'!B15,US!$C:$C,">=5.0",US!$C:$C,"<=5.99")
B22:K22	B22	=COUNTIFS(DE!$F:$F,'LOS (2)'!B15,DE!$D:$D,">=6.0",DE!$D:$D,"<=6.99")+COUNTIFS(US!$E:$E,'LOS (2)'!B15,US!$C:$C,">=6.0",US!$C:$C,"<=6.99")
B23:K23	B23	=COUNTIFS(DE!$F:$F,'LOS (2)'!B15,DE!$D:$D,">=7.0",DE!$D:$D,"<=7.99")+COUNTIFS(US!$E:$E,'LOS (2)'!B15,US!$C:$C,">=7.0",US!$C:$C,"<=7.99")
B24:K24	B24	=COUNTIFS(DE!$F:$F,'LOS (2)'!B15,DE!$D:$D,">=8.0",DE!$D:$D,"<=8.99")+COUNTIFS(US!$E:$E,'LOS (2)'!B15,US!$C:$C,">=8.0",US!$C:$C,"<=8.99")
B25:K25	B25	=COUNTIFS(DE!$F:$F,'LOS (2)'!B15,DE!$D:$D,">=9.0",DE!$D:$D,"<=9.99")+COUNTIFS(US!$E:$E,'LOS (2)'!B15,US!$C:$C,">=9.0",US!$C:$C,"<=9.99")
B26:L26	B26	=SUM(B16:B25)

 

[AudyAnalyst]

if you dont have a raw data sheet, this should work
------------------

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
15	Age	No Need	1	1.5	2	2.5	3	3.5	4	4.5	5	Total
16	Less than 1 Year	7	0	1	1	0	0	0	0	0	0	9
17	1 Year	0	0	0	0	2	2	0	4	1	4	13
18	2 Years	0	0	0	0	0	1	1	0	0	0	2
19	3 Years	0	0	0	0	0	0	1	1	0	0	2
20	4 Years	0	0	0	0	0	0	0	1	0	1	2
21	5 Years	0	2	0	0	0	0	1	0	0	1	4
22	6 Years	0	0	1	0	0	0	1	0	1	0	3
23	7 Years	0	0	0	0	0	2	3	5	0	2	12
24	8 Years	0	0	0	0	0	0	0	0	0	0	0
25	9 Years	0	0	0	0	0	0	0	0	0	0	0
26	Total	7	2	2	1	2	5	7	11	2	8	47
LOS (2)

Cell Formulas
Range	Formula
B16:K16	B16	=COUNTIFS(DE!$F:$F,'LOS (2)'!B15,DE!$D:$D,"<=0.99")+COUNTIFS(US!$E:$E,'LOS (2)'!B15,US!$C:$C,"<=0.99")
L16:L25	L16	=SUM(B16:K16)
B17:K17	B17	=COUNTIFS(DE!$F:$F,'LOS (2)'!B15,DE!$D:$D,">=1.0",DE!$D:$D,"<=1.99")+COUNTIFS(US!$E:$E,'LOS (2)'!B15,US!$C:$C,">=1.0",US!$C:$C,"<=1.99")
B18:K18	B18	=COUNTIFS(DE!$F:$F,'LOS (2)'!B15,DE!$D:$D,">=2.0",DE!$D:$D,"<=2.99")+COUNTIFS(US!$E:$E,'LOS (2)'!B15,US!$C:$C,">=2.0",US!$C:$C,"<=2.99")
B19:K19	B19	=COUNTIFS(DE!$F:$F,'LOS (2)'!B15,DE!$D:$D,">=3.0",DE!$D:$D,"<=3.99")+COUNTIFS(US!$E:$E,'LOS (2)'!B15,US!$C:$C,">=3.0",US!$C:$C,"<=3.99")
B20:K20	B20	=COUNTIFS(DE!$F:$F,'LOS (2)'!B15,DE!$D:$D,">=4.0",DE!$D:$D,"<=4.99")+COUNTIFS(US!$E:$E,'LOS (2)'!B15,US!$C:$C,">=4.0",US!$C:$C,"<=4.99")
B21:K21	B21	=COUNTIFS(DE!$F:$F,'LOS (2)'!B15,DE!$D:$D,">=5.0",DE!$D:$D,"<=5.99")+COUNTIFS(US!$E:$E,'LOS (2)'!B15,US!$C:$C,">=5.0",US!$C:$C,"<=5.99")
B22:K22	B22	=COUNTIFS(DE!$F:$F,'LOS (2)'!B15,DE!$D:$D,">=6.0",DE!$D:$D,"<=6.99")+COUNTIFS(US!$E:$E,'LOS (2)'!B15,US!$C:$C,">=6.0",US!$C:$C,"<=6.99")
B23:K23	B23	=COUNTIFS(DE!$F:$F,'LOS (2)'!B15,DE!$D:$D,">=7.0",DE!$D:$D,"<=7.99")+COUNTIFS(US!$E:$E,'LOS (2)'!B15,US!$C:$C,">=7.0",US!$C:$C,"<=7.99")
B24:K24	B24	=COUNTIFS(DE!$F:$F,'LOS (2)'!B15,DE!$D:$D,">=8.0",DE!$D:$D,"<=8.99")+COUNTIFS(US!$E:$E,'LOS (2)'!B15,US!$C:$C,">=8.0",US!$C:$C,"<=8.99")
B25:K25	B25	=COUNTIFS(DE!$F:$F,'LOS (2)'!B15,DE!$D:$D,">=9.0",DE!$D:$D,"<=9.99")+COUNTIFS(US!$E:$E,'LOS (2)'!B15,US!$C:$C,">=9.0",US!$C:$C,"<=9.99")
B26:L26	B26	=SUM(B16:B25)

Thank you !