總數量 1月到指定月份的姓名 (10521)

G2=SUMPRODUCT(C2:C14*(A2:A14=E2)*(ROW(2:14)<=MATCH(F2,B:B,)))

另解=SUMPRODUCT((A2:A14=E2)*(-LEFTB(B2:B14,2)>=-LEFTB(F2,2))*C2:C14)