问题已解决
怎么用函數(shù)便捷算出D2=A1+B1+C1,并以此類推
FAILED
![](https://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/010/58/06/70_avatar_middle.jpg?t=1651204063)
你好,很高興為你解答
等于sum(a1:c1)
2022 04/16 20:34
![](https://pic1.acc5.cn/010/58/06/70_avatar_middle.jpg?t=1651204063)
趙海龍老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 04/16 20:34
然后向右拖拉就可以你試一下
![](http://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
84785007 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 04/16 21:00
還是不行
![](http://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
84785007 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 04/16 21:01
是要E2=A1+B1+C1+D1,并以此類推
![](https://pic1.acc5.cn/010/58/06/70_avatar_middle.jpg?t=1651204063)
趙海龍老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 04/16 21:02
截圖我看下顯示的什么
![](http://member.chinaacc.com/homes/resources/images/home/avatar/7.jpg)
84785007 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 04/16 21:12
按照您給的公式,第二個(gè)截圖后面沒有加上A1,第三個(gè)截圖后面沒有加上A1和B1的數(shù)
FAILED
FAILED
FAILED
![](https://pic1.acc5.cn/010/58/06/70_avatar_middle.jpg?t=1651204063)
趙海龍老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 04/16 21:20
在A1前面加上$這個(gè)符號(hào)。A1就不會(huì)變化了
![](/wenda/img/newWd/sysp_btn_eye.png)