=sumproduct(isnumber(find("其他",a1:a10))*(len(a1:a10)=8))07版用sumifs
=sumproduct((iserror(find(“其他",a1:a100))=false)*(len(a1:a100)=8)*b1:b100)
