統計各隊各區間數 (9014)

B2:E4=COUNTIFS($J$2:$J$21,$A2,$K$2:$K$21,">="&LOOKUP(99,LEFT(B$1,{1,2})*1),$K$2:$K$21,"<="&RIGHT(LEFT(B$1,LEN(B$1)-1),2))

另解{=INDEX(FREQUENCY(IF($J$2:$J$21=$A2,$K$2:$K$21),LEFT($C$1:$E$1,FIND("-",$C$1:$E$1)-1)-1),COLUMN(A1))