问题已解决
老師,怎么在不同區(qū)域表格用函數(shù)分類匯總求和
FAILED
![](https://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/010/58/06/70_avatar_middle.jpg?t=1651204063)
你好,用sum函數(shù)就可以
2021 03/22 17:28
![](http://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84785034 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 03/22 17:44
公式呢?不會(huì)公式
![](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)
2021 03/22 19:13
一會(huì)給你看下晚點(diǎn)回復(fù)
![](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)
2021 03/22 19:25
每一個(gè)區(qū)域求和的地方輸入sum括號(hào),括號(hào)內(nèi)選擇求和區(qū)域即可
![](http://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84785034 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 03/22 20:04
我需要的是最底下那7個(gè)類別的匯總求和,不是每個(gè)區(qū)域求和
![](http://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84785034 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 03/22 20:05
你打開圖片放大看看
![](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)
2021 03/22 20:05
輸入=把每個(gè)單元格的和加起來
![](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)
2021 03/22 20:05
沒有一步到位的方法
![](http://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84785034 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2021 03/22 20:07
還是要普通那種方法,一個(gè)一個(gè)的點(diǎn)來合計(jì)?
![](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)
2021 03/22 20:11
是的,因?yàn)槟氵@種基礎(chǔ)數(shù)據(jù)就不規(guī)范,通過一次性打不到
![](/wenda/img/newWd/sysp_btn_eye.png)