總和 各名指定筆數內外 (11946)

F2=SUMPRODUCT((COUNTIF(OFFSET(C$2,,,ROW($1:$98)),E2)<=I$2)*(C$2:C$99=E2)*B$2:B$99)

G2=SUMIF(C:C,E2,B:B)-F2

A列需有序號 F2 {=SUMIFS($B:$B,$C:$C,E2,$A:$A,"<="&IFERROR(SMALL(IF($C2:$C99=E2,$A2:$A99),I$2),4^8))