總和 二階段查詢後相乘 (11118)

F2=SUMPRODUCT(N(OFFSET(P$1,MATCH(T(OFFSET(K$1,MATCH(B$2:B$16,J:J,)-1,)),O:O,)-1,))*C$2:C$16*(A$2:A$16=E2))

另解{=SUM(VLOOKUP(T(IF({1},T(OFFSET(K$1,MATCH(B$2:B$16,J:J,)-1,)))),O:P,2,)*C$2:C$16*(A$2:A$16=E2))

另解{=SUM(SUMIF(O:O,VLOOKUP(T(IF(A$2:A$16=E2,B$2:B$16)),J:K,2,),P:P)*C$2:C$16)

另解{=SUM(SUMIF(O:O,T(OFFSET($K$1,MATCH(IF($A$2:$A$16=E2,$B$2:$B$16),J:J,)-1,)),P:P)*$C$2:$C$16)