季總和 依年度 廠商 (11866)

F8:I11=SUMPRODUCT(($A$2:$A$25=F$7)*(LEFT($B$2:$B$25,3)-LOOKUP(999,$F$6:F$6)=0)*(INT((RIGHT($B$2:$B$25,2)-1)/3)+1=ROW(A1))*$C$2:$C$25)