G2:H7{=SUM(IFERROR(N((LEFT($D$2:$D$15,FIND("-",$D$2:$D$15)-2)-MID($D$2:$D$15,FIND("-",$D$2:$D$15)+2,9))*-1^(FIND($F2,$C$2:$C$15)>1)*-1^(G$1=$H$1)>0),""))
J2:J7=COUNTIF(C:C,"*"&F2&"*")
K2:K7{=SUM(IFERROR(IF(FIND(F2,C$2:C$15)=1,LEFT(D$2:D$15,FIND("-",D$2:D$15)-2),MID(D$2:D$15,FIND("-",D$2:D$15)+2,9))*1,))
(後)I2:I7=J2-G2-H2
留言
張貼留言