问题已解决
老師,您好!怎用count公式求小于4大于0區(qū)間的數(shù)
![](https://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/010/17/34/23_avatar_middle.jpg?t=1651203967)
count不行,得用countifs函數(shù),非得用count函數(shù)的話,得用數(shù)組公式了
2020 07/09 20:31
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84784990 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 07/09 20:45
能具體講講嗎,謝謝老師
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84784990 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 07/09 20:56
老師,能把公式寫下嗎
![](https://pic1.acc5.cn/010/17/34/23_avatar_middle.jpg?t=1651203967)
Excel答疑老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 07/09 23:27
=countifs(條件區(qū)域,“<4”,條件區(qū)域,>0)
一共4個參數(shù),學堂里有這個函數(shù)的視頻教程,搜索函數(shù)名就能搜索到
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84784990 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 07/10 08:00
好的,謝謝老師
![](https://pic1.acc5.cn/010/17/34/23_avatar_middle.jpg?t=1651203967)
Excel答疑老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 07/10 08:26
不可氣,多練習你就會成大神
![](/wenda/img/newWd/sysp_btn_eye.png)