如何将以下Excel公式作简化处理(即令其变得简短易用)？

来源：百度知道 编辑：UC知道 时间：2024/05/30 13:06:59
OR(COUNTA(C5:C24)=COUNTIF(C5:C24,N79),COUNTA(C5:C24)=COUNTIF(C5:C24,N80),COUNTA(C5:C24)=COUNTIF(C5:C24,N81),COUNTA(C5:C24)=COUNTIF(C5:C24,N82),COUNTA(C5:C24)=COUNTIF(C5:C24,N83),COUNTA(C5:C24)=COUNTIF(C5:C24,N84),COUNTA(C5:C24)=COUNTIF(C5:C24,N85),COUNTA(C5:C24)=COUNTIF(C5:C24,N86),COUNTA(C5:C24)=COUNTIF(C5:C24,N87),COUNTA(C5:C24)=COUNTIF(C5:C24,N88),COUNTA(C5:C24)=COUNTIF(C5:C24,N89),COUNTA(C5:C24)=COUNTIF(C5:C24,N90),COUNTA(C5:C24)=COUNTIF(C5:C24,N91),COUNTA(C5:C24)=COUNTIF(C5:C24,N92),COUNTA(C5:C24)=COUNTIF(C5:C24,N93),COUNTA(C5:C24)=COUNTIF(C5:C24,N94),COUNTA(C5:C24)=COUNTIF(C5:C24,N95),COUNTA(C5:C24)=COUNTIF(C5:C24,N96),COUNTA(C5:C24)=COUNTIF(C5:C24,N97),COUNTA(C5:C24)=COUNTIF(C5:C24,N98),COUNTA(C5:C24)=COUNTIF(C5:C24,N99))
补充一下：实际的公式是：
IF(AND(C3=N6,OR(COUNTA(C5:C24)=COUNTIF(C5:C24,N79),COUNTA(C5:C24)=COUNTIF(C5:C24,N80),COUNTA(C5:C24)=COUNTIF(C5:C24,N81),COUNTA(C5:C24)=COUNTIF(C5:C24,N82),COUNTA(C5:C24)=COUNTIF(C5:C24,N83),COUNTA(C5:C24)=COUNTIF(C5:C24,N84),COUNTA(C5:C2

=OR(COUNTA(C5:C24)=COUNTIF(C5:C24,N79:N99))
但这样是数组公式。
如果不要数组公式，改成
SUMPRODUCT(--(COUNTA(C5:C24)=COUNTIF(C5:C24,N79:N99)))
如果非要FALSE和TRUE，再改成
SUMPRODUCT(--(COUNTA(C5:C24)=COUNTIF(C5:C24,N79:N99)))>0

=IF(AND(C3=N6,SUMPRODUCT(--(COUNTA(C5:C24)=COUNTIF(C5:C24,N79:N99)))>0)," 所属项目 ","表格填写出错！请参考填表说明！")
其实这样就可以了
=IF(AND(C3=N6,SUMPRODUCT(--(COUNTA(C5:C24)=COUNTIF(C5:C24,N79:N99))))," 所属项目 ","表格填写出错！请参考填表说明！")
下面这个是数组公式
=IF(AND(C3=N6,OR(COUNTA(C5:C24)=COUNTIF(C5:C24,N79:N99)))," 所属项目 ","表格填写出错！请参考填表说明！")

OR(COUNTA(C5:C24)=COUNTIF(C5:C24,INDIRECT("N"&({79;80;81;82;83;84;85;86;87;88;89;90;91;92;93;94;95;96;97;98;99}))))

有实际表格吗？这个最好能看看实际表格，看看你想要实现什么效果来改公式