各客戶 季節數值 取出 (14315)

F2:I5=TEXT(SUMPRODUCT((LOOKUP(ROW(2:12),ROW(2:12)/($A$2:$A$12<>""),$A$2:$A$12)=$E2)*($B$2:$B$12=LEFT(F$1,2))*$C$2:$C$12),"0;;")