C2{=SUM(MMULT(COLUMN(A:G)^0,ISNUMBER(FIND(G$2:G$8,MID(SUBSTITUTE(B2,",",REPT(" ",29)),COLUMN(A:H)*29-28,29)))*H$2:H$8)*MMULT(COLUMN(A:G)^0,IFERROR(SUBSTITUTE(TRIM(MID(SUBSTITUTE(B2,",",REPT(" ",29)),COLUMN(A:H)*29-28,29)),G$2:G$8,)*1,)))
另解{=SUM(IF(ISERR(FIND(G$2:G$8,B2)),,H$2:H$8)*MMULT(IFERROR(SUBSTITUTE(TRIM(MID(SUBSTITUTE(B2,",",REPT(" ",29)),COLUMN(A:H)*29-28,29)),G$2:G$8,)*1,),ROW(1:8)^0))
留言
張貼留言