問題已解決
為什么我這整列求和出是零
![](https://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/010/88/22/51_avatar_middle.jpg?t=2025021714)
因?yàn)槭俏谋拘问絻Υ娴臄?shù)字
2019 11/13 14:25
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84785000 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 11/13 14:27
我要怎么設(shè)置
![](https://pic1.acc5.cn/010/88/22/51_avatar_middle.jpg?t=2025021714)
風(fēng)老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 11/13 14:27
旁邊插入輔助列,h2設(shè)公式=g2*1,然后向下復(fù)制
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84785000 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 11/13 14:34
那是不是要把原來的那一列刪掉
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84785000 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 11/13 14:39
刪除原來一列變這樣的
![](https://pic1.acc5.cn/010/88/22/51_avatar_middle.jpg?t=2025021714)
風(fēng)老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 11/13 15:20
刪除之前需要先將輔助列的公式數(shù)值化,也就是復(fù)制-選擇性粘貼為數(shù)值
![](/wenda/img/newWd/sysp_btn_eye.png)