问题已解决
如果要對(duì)工作表里面有數(shù)據(jù)求和,求大于300小于500的求和,函數(shù)是sumifs嘛怎么用呢
![](https://member.chinaacc.com/homes/resources/images/home/avatar/9.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/011/69/22/07_avatar_middle.jpg?t=1651216774)
同學(xué)您好,=sumif(區(qū)域,">300",求和區(qū)域)-sumif(區(qū)域,">=500",求和區(qū)域)
2020 12/05 12:04
![](https://pic1.acc5.cn/011/69/22/07_avatar_middle.jpg?t=1651216774)
蔡老師5 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 12/05 12:40
幫忙五星好評(píng)哦謝謝
![](/wenda/img/newWd/sysp_btn_eye.png)
如果要對(duì)工作表里面有數(shù)據(jù)求和,求大于300小于500的求和,函數(shù)是sumifs嘛怎么用呢