請假總時數 指定月份 (13240)

J2{=INDEX(B:B,SMALL(IF((MATCH(B$2:B$16&MONTH(D$2:D$16),B$2:B$16&MONTH(D$2:D$16),)=ROW($1:$15))*(MONTH(D$2:D$16)=H$2),ROW($2:$16),99),ROW(A1)))&""

K2=IF(J2="","",SUMPRODUCT((F$2:F$16-E$2:E$16)*(B$2:B$16=J2)*(MONTH(D$2:D$16)=H$2)))