谁能将下面这个公式的日期改为自动按7天来统计单元格的数量,公式如下第一个公式 =COUNTIFS('Total NPD'!$D$6:$D$19998,">=2013-12-28",'Total NPD'!$D$6:$D$19998,"=2014-1-5",'Total NPD'!$D$6:$D$19998,"=2014-1-12",'Total NPD'
来源:学生作业帮助网 编辑:作业帮 时间:2024/08/05 02:44:12
![谁能将下面这个公式的日期改为自动按7天来统计单元格的数量,公式如下第一个公式 =COUNTIFS('Total NPD'!$D$6:$D$19998,](/uploads/image/z/5930694-54-4.jpg?t=%E8%B0%81%E8%83%BD%E5%B0%86%E4%B8%8B%E9%9D%A2%E8%BF%99%E4%B8%AA%E5%85%AC%E5%BC%8F%E7%9A%84%E6%97%A5%E6%9C%9F%E6%94%B9%E4%B8%BA%E8%87%AA%E5%8A%A8%E6%8C%897%E5%A4%A9%E6%9D%A5%E7%BB%9F%E8%AE%A1%E5%8D%95%E5%85%83%E6%A0%BC%E7%9A%84%E6%95%B0%E9%87%8F%2C%E5%85%AC%E5%BC%8F%E5%A6%82%E4%B8%8B%E7%AC%AC%E4%B8%80%E4%B8%AA%E5%85%AC%E5%BC%8F+%3DCOUNTIFS%28%27Total+NPD%27%21%24D%246%3A%24D%2419998%2C%22%3E%3D2013-12-28%22%2C%27Total+NPD%27%21%24D%246%3A%24D%2419998%2C%22%3D2014-1-5%22%2C%27Total+NPD%27%21%24D%246%3A%24D%2419998%2C%22%3D2014-1-12%22%2C%27Total+NPD%27)
x){Eާڞ~9wы3Xu=g<ٜϦ|cUOV<4d峹Kb§S6?[zꆗ:O5|f͓
p#lCB<݂5CKs\U\T̬ u&D24BQfTOkaFf'
E
O;6(Sx6c;^Κb `!Hj
w