请教各位老师，如果将多个COUNTIFS相加求不同结果的函数缩短呀，知道的老师回下，谢谢

zboyong

公式如下：
=COUNTIFS(A!$J:$J,B3,A!$Q:$Q,"是",A!$K:$K,"竣工",A!$AA:$AA,"<=24",A!$C:$C,"cl01",A!$S:$S,"是",A!$O:$O,"是",A!$U:$U,"<>是",A!$Z:$Z,"lan01",A!L:L,J$4)
+COUNTIFS(A!$J:$J,B3,A!$Q:$Q,"是",A!$K:$K,"竣工",A!$AA:$AA,"<=24",A!$C:$C,"cl01",A!$S:$S,"是",A!$O:$O,"是",A!$U:$U,"<>是",A!$Z:$Z,"lan01",A!L:L,J$5)
+COUNTIFS(A!$J:$J,B3,A!$Q:$Q,"是",A!$K:$K,"竣工",A!$AA:$AA,"<=24",A!$C:$C,"cl01",A!$S:$S,"是",A!$O:$O,"是",A!$U:$U,"<>是",A!$Z:$Z,"lan02",A!L:L,J$4)
+COUNTIFS(A!$J:$J,B3,A!$Q:$Q,"是",A!$K:$K,"竣工",A!$AA:$AA,"<=24",A!$C:$C,"cl01",A!$S:$S,"是",A!$O:$O,"是",A!$U:$U,"<>是",A!$Z:$Z,"lan02",A!L:L,J$5)
+COUNTIFS(A!$J:$J,B3,A!$Q:$Q,"是",A!$K:$K,"竣工",A!$AA:$AA,"<=24",A!$C:$C,"cl01",A!$S:$S,"是",A!$O:$O,"是",A!$U:$U,"<>是",A!$Z:$Z,"lan03",A!L:L,J$4)
+COUNTIFS(A!$J:$J,B3,A!$Q:$Q,"是",A!$K:$K,"竣工",A!$AA:$AA,"<=24",A!$C:$C,"cl01",A!$S:$S,"是",A!$O:$O,"是",A!$U:$U,"<>是",A!$Z:$Z,"lan03",A!L:L,J$5)
+COUNTIFS(A!$J:$J,B3,A!$Q:$Q,"是",A!$K:$K,"竣工",A!$AA:$AA,"<=24",A!$C:$C,"cl01+bl01",A!$S:$S,"是",A!$O:$O,"是",A!$U:$U,"<>是",A!$Z:$Z,"lan01",A!L:L,J$4)
+COUNTIFS(A!$J:$J,B3,A!$Q:$Q,"是",A!$K:$K,"竣工",A!$AA:$AA,"<=24",A!$C:$C,"cl01+bl01",A!$S:$S,"是",A!$O:$O,"是",A!$U:$U,"<>是",A!$Z:$Z,"lan01",A!L:L,J$5)
+COUNTIFS(A!$J:$J,B3,A!$Q:$Q,"是",A!$K:$K,"竣工",A!$AA:$AA,"<=24",A!$C:$C,"cl01+bl01",A!$S:$S,"是",A!$O:$O,"是",A!$U:$U,"<>是",A!$Z:$Z,"lan02",A!L:L,J$4)
+COUNTIFS(A!$J:$J,B3,A!$Q:$Q,"是",A!$K:$K,"竣工",A!$AA:$AA,"<=24",A!$C:$C,"cl01+bl01",A!$S:$S,"是",A!$O:$O,"是",A!$U:$U,"<>是",A!$Z:$Z,"lan02",A!L:L,J$5)
+COUNTIFS(A!$J:$J,B3,A!$Q:$Q,"是",A!$K:$K,"竣工",A!$AA:$AA,"<=24",A!$C:$C,"cl01+bl01",A!$S:$S,"是",A!$O:$O,"是",A!$U:$U,"<>是",A!$Z:$Z,"lan03",A!L:L,J$4)
+COUNTIFS(A!$J:$J,B3,A!$Q:$Q,"是",A!$K:$K,"竣工",A!$AA:$AA,"<=24",A!$C:$C,"cl01+bl01",A!$S:$S,"是",A!$O:$O,"是",A!$U:$U,"<>是",A!$Z:$Z,"lan03",A!L:L,J$5)

满坛皆为吾师

将文件打包成.zip or .rar后传上来