問題已解決
您好老師。如下圖:Excel表格里,當(dāng)篩選某天的日期時,如何設(shè)置公式賬戶余額等于R欄里的當(dāng)日結(jié)存金額?謝謝
![](https://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/013/28/52/90_avatar_middle.jpg?t=1714030984)
同學(xué)你好,可以用subtotal公式
2023 09/14 10:48
![](http://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
84784976 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 09/14 10:49
老師,能寫全公式嗎?因為對函數(shù)不熟悉,麻煩了
![](http://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
84784976 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 09/14 10:54
=subtotal()括號里面的內(nèi)容不會輸入
![](https://pic1.acc5.cn/013/28/52/90_avatar_middle.jpg?t=1714030984)
賈小田老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 09/14 10:56
同學(xué)你好,=subtotal(9,需要求和的區(qū)域)
![](http://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
84784976 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 09/14 11:01
老師,您說求和區(qū)域里,單元格是等于當(dāng)日收入?上日金額?當(dāng)日支出 呢,
![](https://pic1.acc5.cn/013/28/52/90_avatar_middle.jpg?t=1714030984)
賈小田老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 09/14 11:17
就是你當(dāng)日結(jié)存金額那一列哈
![](http://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
84784976 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 09/14 11:43
當(dāng)不選擇篩選時,可賬戶余額又不等于當(dāng)日結(jié)存金額
![](https://pic1.acc5.cn/013/28/52/90_avatar_middle.jpg?t=1714030984)
賈小田老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 09/14 11:48
然后你要篩選日期呢,篩選之后就顯示你篩選當(dāng)天余額
![](http://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
84784976 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 09/14 11:50
好的謝謝!就是當(dāng)心領(lǐng)導(dǎo)不篩選日期 誤看錯賬戶余額
![](https://pic1.acc5.cn/013/28/52/90_avatar_middle.jpg?t=1714030984)
賈小田老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 09/14 11:54
不用客氣哈,如果沒有其他問題了麻煩點亮五星好評哦,感謝支持(∩_∩)
![](/wenda/img/newWd/sysp_btn_eye.png)