問題已解決
如何用函數(shù)求紅色部分金額
![](https://member.chinaacc.com/homes/resources/images/home/avatar/1.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/009/47/57/46_avatar_middle.jpg?t=1651203282)
你好
沒明白你的意思,能重述一下嗎
2020 03/13 12:04
![](http://member.chinaacc.com/homes/resources/images/home/avatar/1.jpg)
84785031 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 03/13 13:57
是這樣的,我想將圖一的金額,按類別求和到圖二紅色方框內(nèi)
![](https://pic1.acc5.cn/009/47/57/46_avatar_middle.jpg?t=1651203282)
老江老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 03/13 14:13
用條件求和函數(shù)試試看沒
sumifs()
![](http://member.chinaacc.com/homes/resources/images/home/avatar/1.jpg)
84785031 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 03/13 14:20
L老師,你能幫忙編制一下嗎
![](https://pic1.acc5.cn/009/47/57/46_avatar_middle.jpg?t=1651203282)
老江老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 03/13 14:24
這樣,你把表中數(shù)據(jù)填些,然后發(fā)我,我做個示例
czjrcw@126.com
![](http://member.chinaacc.com/homes/resources/images/home/avatar/1.jpg)
84785031 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 03/13 14:48
我直接把表發(fā)給你
![](https://pic1.acc5.cn/009/47/57/46_avatar_middle.jpg?t=1651203282)
老江老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 03/13 14:50
你一定要填上數(shù)據(jù)(我不知道數(shù)據(jù)是什么樣子的)
![](http://member.chinaacc.com/homes/resources/images/home/avatar/1.jpg)
84785031 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 03/13 15:20
好的,已發(fā)
![](https://pic1.acc5.cn/009/47/57/46_avatar_middle.jpg?t=1651203282)
老江老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 03/13 15:24
不好意思,你再檢查一下呢,我沒收到郵件
![](/wenda/img/newWd/sysp_btn_eye.png)