解决：汇总多张表格数据

1、单位人人工工（1-41-4月月累累计计）材材料料（1-41-4月月累累计计）工工程程维维护护工工程程维维护护预算实绩预算实绩预算实绩预算实绩蔡甸29.9134.4625.4727.0635.4421.402.062.36东西湖27.8620.7229.8430.8528.3811.201.901.24汉南6.627.2612.0512.794.092.640.360.28汉阳100.7695.15144.84146.6051.5163.163.707.00洪山142.55131.20163.85166.7272.1032.562.713.60黄陂40.2450.1042.3946.1528.8

2、621.605.022.40江岸85.0579.36138.59159.2048.7735.522.813.96江汉105.9388.38168.16173.0364.3741.122.414.56江夏92.2870.7282.6685.8845.963.644.180.40桥口53.4854.72109.71112.0341.5837.882.234.20青山69.4259.56106.82110.4236.1450.842.125.64水果湖37.0636.6274.1676.3342.0225.483.892.84武昌113.93109.30170.03176.3762.8435.122

3、.843.92新洲35.7228.0832.5235.1828.15112.886.6812.56分公司940.83865.631301.091358.61590.20495.0442.9054.96想通过查到所在单位后，自动将后面每月表中的对应的数字进行求各，表中只列了四个月，实际需要自动计算12个月的总量，每个月新增一张表后，汇总表要能自己计算累计预算累计实绩完成进度92.8885.2887.9764.0123.1122.98302.08311.91460.88413.76116.52120.26287.87290.68343.99310.20229.72165.28221.62223.4

4、5224.78236.74157.75141.89374.52349.60103.07188.713026.762924.73想通过查到所在单位后，自动将后面每月表中的对应的数字进行求各，表中只列了四个月，实际需要自动计算12个月的总量，每个月新增一张表后，汇总表要能自己计算单位人人工工材材料料工工程程维维护护工工程程维维护护预算实绩预算实绩预算实绩预算城区洪山35.6432.8040.9641.6818.038.140.68水果湖9.279.1518.5419.0810.506.370.97武昌28.4827.3342.5144.0915.718.780.71江汉26.4822.0942.0

5、443.2616.0910.280.60江岸21.2619.8434.6539.8012.198.880.70桥口13.3713.6827.4328.0110.409.470.56汉阳25.1923.7936.2136.6512.8815.790.92青山17.3514.8926.7027.619.0412.710.53郊区新洲8.937.028.138.807.0428.221.67江夏23.0717.6820.6721.4711.490.911.05黄陂10.0612.5310.6011.547.225.401.26东西湖6.975.187.467.717.092.800.47汉南1.66

6、1.823.013.201.020.660.09蔡甸7.488.616.376.778.865.350.52分公司235.37216.40325.27339.70147.55123.7610.73合合计计实绩预算实绩0.90115.22103.440.7139.4435.470.9893.6387.401.1486.0077.550.9971.9772.671.0555.4155.861.7575.5277.981.4156.2059.193.1425.7747.180.1057.4341.320.6029.1330.060.3121.9916.000.075.785.740.5923.222

7、1.3213.75774.35750.36材材料料维维护护单位人人工工材材料料工工程程维维护护工工程程维维护护预算实绩预算实绩预算实绩预算城区洪山35.6432.8040.9641.6818.038.140.68水果湖9.279.1518.5419.0810.506.370.97武昌28.4827.3342.5144.0915.718.780.71江汉26.4822.0942.0443.2616.0910.280.60江岸21.2619.8434.6539.8012.198.880.70桥口13.3713.6827.4328.0110.409.470.56汉阳25.1923.7936.2136

8、.6512.8815.790.92青山17.3514.8926.7027.619.0412.710.53郊区新洲8.937.028.138.807.0428.221.67江夏23.0717.6820.6721.4711.490.911.05黄陂10.0612.5310.6011.547.225.401.26东西湖6.975.187.467.717.092.800.47汉南1.661.823.013.201.020.660.09蔡甸7.488.616.376.778.865.350.52分公司235.37216.40325.27339.70147.55123.7610.73合合计计实绩预算实绩0

9、.90115.22103.440.7139.4435.470.9893.6387.401.1486.0077.550.9971.9772.671.0555.4155.861.7575.5277.981.4156.2059.193.1425.7747.180.1057.4341.320.6029.1330.060.3121.9916.000.075.785.740.5923.2221.3213.75774.35750.36材材料料维维护护单位人人工工材材料料工工程程维维护护工工程程维维护护预算实绩预算实绩预算实绩预算城区洪山35.6432.8040.9641.6818.038.140.68水果湖

10、9.279.1518.5419.0810.506.370.97武昌28.4827.3342.5144.0915.718.780.71江汉26.4822.0942.0443.2616.0910.280.60江岸21.2619.8434.6539.8012.198.880.70桥口13.3713.6827.4328.0110.409.470.56汉阳25.1923.7936.2136.6512.8815.790.92青山17.3514.8926.7027.619.0412.710.53郊区新洲8.937.028.138.807.0428.221.67江夏23.0717.6820.6721.4711

11、.490.911.05黄陂10.0612.5310.6011.547.225.401.26东西湖6.975.187.467.717.092.800.47汉南1.661.823.013.201.020.660.09蔡甸7.488.616.376.778.865.350.52分公司235.37216.40325.27339.70147.55123.7610.73合合计计实绩预算实绩0.90115.22103.440.7139.4435.470.9893.6387.401.1486.0077.550.9971.9772.671.0555.4155.861.7575.5277.981.4156.205

12、9.193.1425.7747.180.1057.4341.320.6029.1330.060.3121.9916.000.075.785.740.5923.2221.3213.75774.35750.36材材料料维维护护单位人人工工材材料料工工程程维维护护工工程程维维护护预算实绩预算实绩预算实绩预算城区洪山35.6432.8040.9641.6818.038.140.68水果湖9.279.1518.5419.0810.506.370.97武昌28.4827.3342.5144.0915.718.780.71江汉26.4822.0942.0443.2616.0910.280.60江岸21.26

13、19.8434.6539.8012.198.880.70桥口13.3713.6827.4328.0110.409.470.56汉阳25.1923.7936.2136.6512.8815.790.92青山17.3514.8926.7027.619.0412.710.53郊区新洲8.937.028.138.807.0428.221.67江夏23.0717.6820.6721.4711.490.911.05黄陂10.0612.5310.6011.547.225.401.26东西湖6.975.187.467.717.092.800.47汉南1.661.823.013.201.020.660.09蔡甸7

14、.488.616.376.778.865.350.52分公司235.37216.40325.27339.70147.55123.7610.7335.64142.55389.2737.0633328.48113.927226.48105.931321.2685.0503313.3753.4766725.19100.763317.3569.419678.9335.7231723.0792.2798310.0640.243336.9727.86351.666.627.4829.91117235.37941.46合合计计实绩预算实绩0.90115.22103.440.7139.4435.470.989

15、3.6387.401.1486.0077.550.9971.9772.671.0555.4155.861.7575.5277.981.4156.2059.193.1425.7747.180.1057.4341.320.6029.1330.060.3121.9916.000.075.785.740.5923.2221.3213.75774.35750.36材材料料维维护护单位人人工工材材料料工工程程维维护护工工程程维维护护预算实绩预算实绩预算实绩预算城区洪山水果湖武昌江汉江岸桥口汉阳青山郊区新洲江夏黄陂东西湖汉南蔡甸分公司合合计计实绩预算实绩材材料料维维护护单位人人工工材材料料工工程程维维护护工

16、工程程维维护护预算实绩预算实绩预算实绩预算城区洪山水果湖武昌江汉江岸桥口汉阳青山郊区新洲江夏黄陂东西湖汉南蔡甸分公司合合计计实绩预算实绩材材料料维维护护单位人人工工材材料料工工程程维维护护工工程程维维护护预算实绩预算实绩预算实绩预算城区洪山水果湖武昌江汉江岸桥口汉阳青山郊区新洲江夏黄陂东西湖汉南蔡甸分公司合合计计实绩预算实绩材材料料维维护护单位人人工工材材料料工工程程维维护护工工程程维维护护预算实绩预算实绩预算实绩预算城区洪山水果湖武昌江汉江岸桥口汉阳青山郊区新洲江夏黄陂东西湖汉南蔡甸分公司合合计计实绩预算实绩材材料料维维护护单位人人工工材材料料工工程程维维护护工工程程维维护护预算实绩预算实绩预算实绩预算城区洪山水果湖武昌江汉江岸桥口汉阳青山郊区新洲江夏黄陂东西湖汉南蔡甸分公司合合计计实绩预算实绩材材料料维维护护单位人人工工材材料料工工程程维维护护工工程程维维护护预算