问题已解决
想求圖片里頭區(qū)間的個數(shù),公式該怎么輸啊
FAILED
![](https://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/011/91/71/85_avatar_middle.jpg?t=1651216838)
您好,根據(jù)您的圖片,countifs里加and
2021 12/04 13:49
![](http://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
84784973 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 12/04 13:51
怎么加阿
![](https://pic1.acc5.cn/011/91/71/85_avatar_middle.jpg?t=1651216838)
小林老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 12/04 13:51
您好,您把您的圖片公式復制下發(fā)下,方便編輯
![](http://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
84784973 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 12/04 13:52
=COUNTIFS(D:D,">=10",D:D,"<50")
是這樣的
![](https://pic1.acc5.cn/011/91/71/85_avatar_middle.jpg?t=1651216838)
小林老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 12/04 13:53
您好,感謝您的回復,=COUNTIFS(and(D:D,">=10",D:D,"<50"))
![](http://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
84784973 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 12/04 13:57
剛才還是不對
FAILED
![](https://pic1.acc5.cn/011/91/71/85_avatar_middle.jpg?t=1651216838)
小林老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 12/04 14:01
您好,您輸入=COUNTIFS(D:D,">=10",D:D,"<50"),這個公式達不到您的要求?哪部分沒達到?
![](/wenda/img/newWd/sysp_btn_eye.png)