E3{=IF(D3="","",SUM(RIGHT(SMALL(IFERROR(MID(A$2:A$7,RIGHT(SMALL(IFERROR(FIND(COLUMN(A:I),MID(A$2:A$7,FIND(D3,A$2:A$7),99)&1/17)+FIND(D3,A$2:A$7)-1,99)+ROW(2:7)/1%,ROW($1:$6)*9-8),2),{1,2,3,4,5})*1,)+ROW(2:7)*10^6,ROW($1:$6)*5),6)*1)-SUMIF(D4:D9,"*"&D3&"*",E4:E9))
留言
張貼留言