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/07/11 22:03:45
![EXCEL统计中COUNTIFS函数的用法=COUNTIFS(I2:I417,](/uploads/image/z/7841125-37-5.jpg?t=EXCEL%E7%BB%9F%E8%AE%A1%E4%B8%ADCOUNTIFS%E5%87%BD%E6%95%B0%E7%9A%84%E7%94%A8%E6%B3%95%3DCOUNTIFS%28I2%3AI417%2C%22%3D1%22%2CAJ2%3AAJ417%2C%22%3D1%22%2CI418%3AI833%2C%22%3D7%22%2CAJ418%3AAJ833%2C%22%3D1%22%2CI834%3AI1249%2C%22%3D5%22%2CAJ834%3AAJ1249%2C%22%3D1%22%2CI1250%3AI1665%2C%22%3D3%22%2CAJ1250%3AAJ1665%2C%22%3D1%22%29%E8%BF%99%E4%B8%AA%E5%85%AC%E5%BC%8F%E5%93%AA%E9%87%8C%E9%94%99%E4%BA%86%3F%E6%95%B0%E6%8D%AE%E4%B8%8A%E8%82%AF%E5%AE%9A%E6%98%AF%E6%B2%A1%E9%97%AE%E9%A2%98%E7%9A%84%2C%E8%B0%A2%E8%B0%A2%21)
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行的条件.