問(wèn)題已解決
我要怎么樣才可以把篩選出來(lái)的數(shù)字相加?
![](https://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/011/61/32/99_avatar_middle.jpg?t=1714043123)
用subtotal函數(shù)就可以
2020 04/07 12:34
![](http://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84784974 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 04/07 12:49
不理解這個(gè)函數(shù)應(yīng)該怎么用?我算出來(lái)的結(jié)果不對(duì)
![](https://pic1.acc5.cn/011/61/32/99_avatar_middle.jpg?t=1714043123)
鐘存老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 04/07 13:05
參數(shù)選9,范圍就是你要求和的那一列
![](http://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84784974 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 04/07 13:34
好的,謝謝老師
![](https://pic1.acc5.cn/011/61/32/99_avatar_middle.jpg?t=1714043123)
鐘存老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 04/07 17:42
不客氣,祝您學(xué)習(xí)愉快
![](/wenda/img/newWd/sysp_btn_eye.png)