问题已解决
Excel怎么用subtotal篩選求和沒有用呢?
FAILED
![](https://member.chinaacc.com/homes/resources/images/home/avatar/9.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/011/92/76/72_avatar_middle.jpg?t=1651216840)
同學(xué)您好。如圖所示。
FAILED
2021 07/22 16:18
![](http://member.chinaacc.com/homes/resources/images/home/avatar/9.jpg)
84784979 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 07/22 16:19
對,怎么了?
![](http://member.chinaacc.com/homes/resources/images/home/avatar/9.jpg)
84784979 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 07/22 16:19
問題是我現(xiàn)實不出來求和
![](http://member.chinaacc.com/homes/resources/images/home/avatar/9.jpg)
84784979 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 07/22 16:19
顯示不出來
![](http://member.chinaacc.com/homes/resources/images/home/avatar/9.jpg)
84784979 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 07/22 16:20
篩選之后合計就沒了
![](https://pic1.acc5.cn/011/92/76/72_avatar_middle.jpg?t=1651216840)
何老師13 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 07/22 16:25
同學(xué)您好。把9改成109試一下?;蛘甙涯悻F(xiàn)在的表復(fù)制到新表試一下。老師這邊就是能夠看得見數(shù)字的。
![](http://member.chinaacc.com/homes/resources/images/home/avatar/9.jpg)
84784979 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 07/22 17:00
還是不行
![](https://pic1.acc5.cn/011/92/76/72_avatar_middle.jpg?t=1651216840)
何老師13 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2021 07/22 17:14
你不要在數(shù)字旁邊設(shè)置單位,加元這些。然后把數(shù)字那列設(shè)置成數(shù)值格式。
![](/wenda/img/newWd/sysp_btn_eye.png)