问题已解决
怎樣將兩張表格里人員金額進(jìn)行統(tǒng)計(jì)?怎樣將兩張表格復(fù)制到一張表格按照姓名和金額進(jìn)行統(tǒng)計(jì)排序
![](https://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
您好,用SUMIFS函數(shù)可以,您的表格能看一下么,這樣好寫公式
2023 10/24 22:13
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784955 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 10/24 22:50
另一張表格復(fù)制過來怎樣按照姓名對應(yīng)排序
![](http://member.chinaacc.com/homes/resources/images/home/avatar/5.jpg)
84784955 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 10/24 22:51
只有姓名和金額兩行,但是兩個(gè)表里的姓名排序不一樣
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 10/24 22:56
您好,復(fù)制過來以后重新排序嘛,按姓名列排
![](/wenda/img/newWd/sysp_btn_eye.png)