EXCEL统计中COUNTIFS函数的用法=COUNTIFS(I2:I417,"=1",AJ2:AJ417,"=1",I418:I833,"=7",AJ418:AJ833,"=1",I834:I1249,"=5",AJ834:AJ1249,"=1",I1250:I1665,"=3",AJ1250:AJ1665,"=1")这个公式哪里错了?数据上肯定是没问题的,谢谢!
来源:学生作业帮助网 编辑:作业帮 时间:2024/05/11 20:04:35
EXCEL统计中COUNTIFS函数的用法=COUNTIFS(I2:I417,"=1",AJ2:AJ417,"=1",I418:I833,"=7",AJ418:AJ833,"=1",I834:I1249,"=5",AJ834:AJ1249,"=1",I1250:I1665,"=3",AJ1250:AJ1665,"=1")这个公式哪里错了?数据上肯定是没问题的,谢谢!
EXCEL统计中COUNTIFS函数的用法
=COUNTIFS(I2:I417,"=1",AJ2:AJ417,"=1",I418:I833,"=7",AJ418:AJ833,"=1",I834:I1249,"=5",AJ834:AJ1249,"=1",I1250:I1665,"=3",AJ1250:AJ1665,"=1")
这个公式哪里错了?数据上肯定是没问题的,谢谢!
EXCEL统计中COUNTIFS函数的用法=COUNTIFS(I2:I417,"=1",AJ2:AJ417,"=1",I418:I833,"=7",AJ418:AJ833,"=1",I834:I1249,"=5",AJ834:AJ1249,"=1",I1250:I1665,"=3",AJ1250:AJ1665,"=1")这个公式哪里错了?数据上肯定是没问题的,谢谢!
这个公式应该是求“l列2到417”的个数,
但条件有问题:I2:I417,"=1",AJ2:AJ417,"=1",I418:I833,"=7",AJ418:AJ833,"=1",I834:I1249,"=5",AJ834:AJ1249,"=1",I1250:I1665,"=3",AJ1250:AJ1665,"=1"
条件应该都在2到417行才对!即“I418:I833,"=7"”不对,应该是改为“I2:I417,"=7"”.
COUNTIFS统计的必须是个二维表,不是交错对应统计,既然是统计2-417行,那条件也应是2-417行的条件.