總數排序後 再計算細數 (15243)

G3:G7{=IFERROR(INDEX(B:B,RIGHT(LARGE(IF(MATCH(B$2:B$24,B:B,)=ROW($2:$24),SUMIF(B:B,B$2:B$24,D:D)/1%+ROW($2:$24)),ROW(A1)),2)),"")

H3:J7=IF($G3="","",SUMIFS($D:$D,$B:$B,$G3,$C:$C,H$2))