[已解决]工作表查找求和

dahai3299

请帮忙汇总求和，万分感谢！

最佳答案

月排行榜 / 总排行榜

心正意诚身修

2016-3-11 14:36

=SUM(SUMIFS(INDIRECT("'"&ROW($A$1:$A$2)&"月排名'!F:F"),indirect("'"&ROW($A$1:$A$2)&"月排名'!B:B"),B3,INDIRECT("'"&ROW($A$1:$A$2)&"月排名'!C:C"),C3))
我用的2003版．．用不了SUMIFS．數組公式．你拿去試一下．應該　是可以的．

跳转到最佳答案楼层

心正意诚身修

=SUM(SUMIFS(INDIRECT("'"&ROW($A$1:$A$2)&"月排名'!F:F"),indirect("'"&ROW($A$1:$A$2)&"月排名'!B:B"),B3,INDIRECT("'"&ROW($A$1:$A$2)&"月排名'!C:C"),C3))
我用的2003版．．用不了SUMIFS．數組公式．你拿去試一下．應該　是可以的．

huangcaiguang

二楼大戚的可以贴，我帮你贴完整哈=SUM(SUMIFS(INDIRECT("'"&ROW($A$1:$A$2)&"月排名'!F:F"),INDIRECT("'"&ROW($A$1:$A$2)&"月排名'!B:B"),B3,INDIRECT("'"&ROW($A$1:$A$2)&"月排名'!C:C"),C3,INDIRECT("'"&ROW($A$1:$A$2)&"月排名'!D:D"),D3,INDIRECT("'"&ROW($A$1:$A$2)&"月排名'!E:E"),E3))
常规出货=SUM(SUMIFS(INDIRECT("'"&ROW($A$1:$A$2)&"月排名'!G:G"),INDIRECT("'"&ROW($A$1:$A$2)&"月排名'!B:B"),B3,INDIRECT("'"&ROW($A$1:$A$2)&"月排名'!C:C"),C3,INDIRECT("'"&ROW($A$1:$A$2)&"月排名'!D:D"),D3,INDIRECT("'"&ROW($A$1:$A$2)&"月排名'!E:E"),E3))
出货总金额=SUM(SUMIFS(INDIRECT("'"&ROW($A$1:$A$2)&"月排名'!H:H"),INDIRECT("'"&ROW($A$1:$A$2)&"月排名'!B:B"),B3,INDIRECT("'"&ROW($A$1:$A$2)&"月排名'!C:C"),C3,INDIRECT("'"&ROW($A$1:$A$2)&"月排名'!D:D"),D3,INDIRECT("'"&ROW($A$1:$A$2)&"月排名'!E:E"),E3))