年區間 總數 (14385)

E3{=MIN(IF($B$2:$B$99,FLOOR($B$2:$B$99,5)))+ROW(A1)*5-5&"-"&MIN(IF($B$2:$B$99,FLOOR($B$2:$B$99,5)))+ROW(A1)*5-1

F3=SUMIFS(C$2:C$99,B$2:B$99,">="&LEFT(E3,FIND("-",E3)-1),B$2:B$99,"<="&MID(E3,FIND("-",E3)+1,9))

G3=SUM(F$3:F3)/SUM(C:C)