如何汇总取数，求大神帮忙做一下公式

wm863636363

如何汇总取数，求大神帮忙做一下公式

秋水长天陶陶

C2=SUMIFS(取得发票明细!C:C,取得发票明细!B:B,汇总查询!$A$2,取得发票明细!A:A,汇总查询!B2)
D2=SUMIFS(付款明细!C:C,付款明细!B:B,汇总查询!$A$2,付款明细!A:A,汇总查询!B2)
下拉

晨光晞微

=SUMIFS(取得发票明细!C:C,取得发票明细!A:A,B2,取得发票明细!B:B,A$2)
=SUMIFS(付款明细!C:C,付款明细!A:A,B2,付款明细!B:B,A$2)

yao_ashuai

=SUMIFS(取得发票明细!C:C,取得发票明细!B:B,汇总查询!A2,取得发票明细!A:A,汇总查询!B2)
=SUMIFS(付款明细!C:C,付款明细!B:B,汇总查询!A2,付款明细!A:A,汇总查询!B2)

yao_ashuai

你看下这样是否可以

三秋之叶

=SUMIFS(INDIRECT(LEFT(C$1,LEN(C$1)-2)&"明细!C:C"),INDIRECT(LEFT(C$1,LEN(C$1)-2)&"明细!A:A"),$B2,INDIRECT(LEFT(C$1,LEN(C$1)-2)&"明细!B:B"),$A$2)

hbzql

=SUMIFS(取得发票明细!$C:$C,取得发票明细!$B:$B,A2,取得发票明细!$A:$A,B2)
=SUMIFS(付款明细!$C:$C,付款明细!$B:$B,A2,付款明细!$A:$A,B2)

三秋之叶

=SUMIFS(INDIRECT({"取得发票明细","付款明细"}&"!C:C"),INDIRECT({"取得发票明细","付款明细"}&"!A:A"),$B2,INDIRECT({"取得发票明细","付款明细"}&"!B:B"),$A$2)

雅筠

=SUMIFS(表2[发票金额],表2[月份],$M3,表2[公司名],$L$3)
=SUMIFS(表1[付款金额],表1[月份],$M3,表1[公司名],$L$3)
建议将取得发票明细和付款明细表都用【Ctrl+T】变成超级表，感觉方便点。

我的城市你来过

=SUM(IF(INDIRECT(SUBSTITUTE(C$1,"金额","明细")&"!A:A")&INDIRECT(SUBSTITUTE(C$1,"金额","明细")&"!b:b")=$B2&$A$2,INDIRECT(SUBSTITUTE(C$1,"金额","明细")&"!c:c"),""))