總和 有類似與多出字樣的處理 (13151)

F2{=SUM(INDEX(I:I,N(IF({1},RIGHT(SMALL(IFERROR((FIND(H$2:H$99,"@"&MID(SUBSTITUTE(E2,",",REPT(" ",99)),COLUMN(A:I)*99-98,99))>1)*LEN(H$2:H$99),)/1%+COLUMN(A:I)/1%%+ROW($2:$99),COLUMN(A:I)*98),2)*1))))



留言