第1个回答 2013-03-29
f1公式:
=count(find("04,",a1:a10&","&b1:b10&","&c1:c10&","&d1:d10&","&e1:e10&",")*find("08,",a1:a10&","&b1:b10&","&c1:c10&","&d1:d10&","&e1:e10&",")*find("10,",a1:a10&","&b1:b10&","&c1:c10&","&d1:d10&","&e1:e10&","))
数组公式,按ctrl+shift+enter三键结束本回答被提问者采纳
第2个回答 2013-03-29
=SUM(IF(ISERROR(SEARCH("04",A1:E10)),IF(ISERROR(SEARCH("08",A1:E10)),IF(ISERROR(SEARCH(10,A1:E10)),0,1))))
同时按CTRL SHIFT 回车键
第3个回答 2013-03-29
在F1单元格输入公式:=IF(AND(COUNTIF(A1:E1,8)>0,COUNTIF(A1:E1,4)>0,COUNTIF(A1:E1,10)>0),4,"")