F2:F5=SUM(OFFSET(C$1,MATCH(E2,A:A,)-1,,-LOOKUP(1,-MATCH(1=1,OFFSET(A$1,MATCH(E2,A:A,),,9)<>"",{1,0}))))
另解F2:F5=SUMPRODUCT((LOOKUP(ROW(2:12),ROW(2:12)/(A$2:A$12<>""),A$2:A$12)=E2)*C$2:C$12)
I2:N5=SUMPRODUCT((LOOKUP(ROW(1:11),ROW(1:11)/($A$2:$A$12<>""),$A$2:$A$12)=$H2)*($B$2:$B$12=I$1)*$C$2:$C$12)
留言
張貼留言