問題已解決
有沒有表格大佬教教我怎么引用數(shù)據(jù)啊 我想把圖一表格里面的數(shù)據(jù)全部引用到圖二里面來 然后又把圖二的數(shù)據(jù)作為初期數(shù)引用到圖三來 求指教
![](https://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
Jack老師
金牌答疑老師
職稱:中級(jí)會(huì)計(jì)師,注冊(cè)會(huì)計(jì)師,CMA,經(jīng)濟(jì)師,稅務(wù)師,初級(jí)會(huì)計(jì)師
您好,使用vlooup函數(shù),匹配到原表Q列的數(shù)據(jù),得到應(yīng)收余額,同理應(yīng)付余額也可以這樣匹配。
2023 03/10 11:47
![](http://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
84784983 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 03/10 16:24
搞不定啊(大哭)
Jack老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 03/10 16:39
您好,按照這個(gè)公式填:VLOOKUP(B3,B:Q,16,0),這個(gè)B:Q建議直接選中數(shù)據(jù)表的這個(gè)區(qū)域。
![](http://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
84784983 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 03/10 16:54
不行,Q是17!而且我總表列了“應(yīng)收”“應(yīng)付”兩欄
![](http://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
84784983 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 03/10 16:56
明細(xì)表是這么匯總的
Jack老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 03/10 16:58
您好,在B:Q這個(gè)范圍內(nèi),是第16沒錯(cuò)的,B列您的名稱需要做統(tǒng)一,不然公式也沒辦法匯總。
然后您應(yīng)付應(yīng)該也有張表吧,應(yīng)付也按一個(gè)邏輯做,能取到數(shù)的。
![](http://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
84784983 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 03/10 17:06
沒有,應(yīng)收應(yīng)付在一個(gè)表
![](http://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
84784983 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 03/10 17:07
那我分開做兩個(gè)表格,然后引用數(shù)據(jù)
![](http://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
84784983 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 03/10 17:07
B列名稱做統(tǒng)一是什么意思?
Jack老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 03/10 17:11
您好,統(tǒng)一叫白駒車隊(duì),應(yīng)付另做一張表,不要叫白駒車隊(duì)(應(yīng)付)。
![](http://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
84784983 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 03/10 17:14
用函數(shù)sumif呢?
![](http://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
84784983 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 03/10 17:15
數(shù)據(jù)引用不出來啊
![](http://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
84784983 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2023 03/10 17:18
那我是引用哪里出了問題呢?
Jack老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2023 03/10 17:28
您好,如果是同一個(gè)名稱下有多個(gè)數(shù)據(jù),那么就使用sumif函數(shù),您把您的引用發(fā)一下呢。
![](/wenda/img/newWd/sysp_btn_eye.png)