麻烦老师们帮忙优化一下公式,3D 数据对比的函数公式运行太大了,麻烦懂的老师帮忙优化,谢谢
=IF(AND(SUM(COUNTIF($C6:$E6,{1,2,3,5,7}))=3),"质",SUM(1,AX5))
=IF(AND(SUM(COUNTIF($C6:$E6,{1,2,3,5,7}))>1),"2 质",SUM(1,AY5))
=IF(AND(SUM(COUNTIF($C6:$E6,{0,4,6,8,9}))>1),"2 合",SUM(1,AZ5))
=IF(AND(SUM(COUNTIF($C6:$E6,{0,4,6,8,9}))=3),"合",SUM(1,BA5))