降冪排序 合計後 (11120)

 

  E2:E7{=INDEX(B:B,RIGHT(MAX(IF(COUNTIF(E$1:E1,B$2:B$16)=0,SUMIF(B:B,B$2:B$16,C:C)/1%+ROW($2:$16),99),ROW(A1)),2))&""

F2:F7=IF(E2="","",SUMIF(B:B,E2,C:C))