總和 英文字往下數字 (11709)

E2=SUMPRODUCT((LOOKUP(ROW($1:$15),ROW($1:$15)/ISERR(-B$2:B$16),B$2:B$16)=D2)*N(+B$2:B$16))

另解{=SUM(OFFSET(B$1,MATCH(D2,B:B,),,MATCH(1=1,ISERR(0/OFFSET(B$1,MATCH(D2,B:B,),,9)),)-1))