按项目汇总

mcy318

每一个表格中项目是乱的，没有按顺序的，要求按汇总表的项目顺序，进行汇总到第一张表格中，后面各部门的费用明细是乱的，不排序。 各部门费用预算.rar (29.34 KB, 下载次数: 13)

2020-1-15 09:38 上传

点击文件名下载附件

干勇平

要么先把后面表按项目排序，要么后面表搞辅助列，按项目排序再隐藏

solextrade

E7 =SUM(SUMIF(INDIRECT({"质量","财务","采购","技术","PIE","PMC"}&"!B:B"),$B7,INDIRECT({"质量","财务","采购","技术","PIE","PMC"}&"!C",)))

干勇平

=SUM(SUMIF(INDIRECT({"质量","财务","采购","技术","PIE","PMC"}&"!b:b"),$B7,INDIRECT({"质量","财务","采购","技术","PIE","PMC"}&"!e:e")))

干勇平

=SUM(SUMIF(INDIRECT(R7:R12&"!b:b"),$B7,INDIRECT(R7:R12&"!e:e")))，在R7:R12输入质量...PMC各表名，见图

jians0529

=SUM(SUMIF(INDIRECT({"质量";"财务";"采购";"技术";"PIE";"PMC"}&"!$B:$B"),$B7,INDIRECT({"质量";"财务";"采购";"技术";"PIE";"PMC"}&TEXT(CHAR(COLUMN(A1)+68),"\!@:@"))))
右拉下拉

毛利的乖乖熊

汇总表E7数入数组公式：
=SUM(SUMIF(INDIRECT({"质量","财务","采购","技术","PIE","PMC"}&"!$B$7:$B$12"),$B7,OFFSET(INDIRECT({"质量","财务","采购","技术","PIE","PMC"}&"!E$7:E$12"),,COLUMN(A$1)-1)))
右拉下拉