asimov

回復  偉婕
這公式確實有漏洞
如果D欄的國別在A欄不只出現一次就出錯了
再想想看除了VBA還有其他甚麼方 ...
Hsieh 發表於 2010-10-2 16:26

試試
E2
=SUMPRODUCT((ISNUMBER(FIND(";"&SUBSTITUTE(D2," ","")&";",";"&SUBSTITUTE($A$2:$A$75," ","")&";"))*1))