汇总统计类-数据汇总-案例1汇总多个表格中相同单元格的.xls
20102010年年销销售售汇汇总总表表序号品名销售量销售额1彩电7195752002冰箱6454508553电磁炉5821158184热水器7301095005洗衣机5844485126空调5727367367电脑61623950088自行车379636729手机64463627210饮水机5805104011电扇6232990412吸尘器5487014413洗碗机67812746414缝纫机4659207015电暖器47613328合计88415915523利用sum函数支持多表三维引用的特性，快速输入求和公式进行汇总。输入=sum(*!c3)通配符*表示匹配任意字符，?表示匹配单个字符，比如输入=sum(?!c3)表示统计10月-11月的数据另外可以用工作组方式写函数，输入”=sum(“选择1月C3 单元格 按住shift键，选择10月 回车销销售售月月报报表表序号品名销售量销售额1彩电3124,8002冰箱4732,8533电磁炉285,5724热水器477,0505洗衣机5643,0086空调4861,8247电脑62241,0568自行车9215,4569手机32,96410饮水机443,87211电扇592,83212吸尘器546,91213洗碗机6111,46814缝纫机132,57415电暖器361,008合计681463,249销销售售月月报报表表序号品名销售量销售额1彩电7358,4002冰箱7351,0273电磁炉8617,1144热水器639,4505洗衣机5945,3126空调3646,3687电脑91353,8088自行车416,8889手机5958,29210饮水机524,57611电扇442,11212吸尘器668,44813洗碗机9217,29614缝纫机599015电暖器802,240合计920682,321销销售售月月报报表表序号品名销售量销售额1彩电8467,2002冰箱9767,8033电磁炉6112,1394热水器8012,0005洗衣机8666,0486空调7799,1767电脑53206,0648自行车11689手机4847,42410饮水机141,23211电扇904,32012吸尘器8010,24013洗碗机489,02414缝纫机9518,81015电暖器256合计916621,704销销售售月月报报表表序号品名销售量销售额1彩电3326,4002冰箱7552,4253电磁炉377,3634热水器9313,9505洗衣机7658,3686空调3848,9447电脑1038,8808自行车58409手机65,92810饮水机897,83211电扇733612吸尘器182,30413洗碗机438,08414缝纫机254,95015电暖器9252合计564276,856销销售售月月报报表表序号品名销售量销售额1彩电9979,2002冰箱3323,0673电磁炉397,7614热水器7210,8005洗衣机4635,3286空调5672,1287电脑36139,9688自行车7512,6009手机5958,29210饮水机870411电扇291,39212吸尘器564013洗碗机264,88814缝纫机5110,09815电暖器932,604合计727459,470销销售售月月报报表表序号品名销售量销售额1彩电8164,8002冰箱6948,2313电磁炉9017,9104热水器162,4005洗衣机9673,7286空调6077,2807电脑69268,2728自行车91,5129手机8079,04010饮水机897,83211电扇934,46412吸尘器131,66413洗碗机9117,10814缝纫机6613,06815电暖器4112合计926677,421销销售售月月报报表表序号品名销售量销售额1彩电9576,0002冰箱8559,4153电磁炉8416,7164热水器527,8005洗衣机1511,5206空调5368,2647电脑47182,7368自行车6010,0809手机5655,32810饮水机726,33611电扇291,39212吸尘器91,15213洗碗机397,33214缝纫机101,98015电暖器10280合计716506,331销销售售月月报报表表序号品名销售量销售额1彩电18002冰箱117,6893电磁炉81,5924热水器355,2505洗衣机2720,7366空调0-7电脑1454,4328自行车0-9手机5857,30410饮水机776,77611电扇803,84012吸尘器455,76013洗碗机6412,03214缝纫机101,98015电暖器34952合计464179,143销销售售月月报报表表序号品名销售量销售额1彩电7560,0002冰箱3826,5623电磁炉509,9504热水器304,5005洗衣机107,6806空调5368,2647电脑45174,9608自行车46729手机4645,44810饮水机554,84011电扇854,08012吸尘器769,72813洗碗机305,64014缝纫机6312,47415电暖器14392合计674435,190销销售售月月报报表表序号品名销售量销售额1彩电3830,4002冰箱5135,6493电磁炉6011,9404热水器7511,2505洗衣机1713,0566空调91117,2087电脑94365,4728自行车264,3689手机8785,95610饮水机18811电扇411,96812吸尘器8110,36813洗碗机7814,66414缝纫机275,34615电暖器31868合计798708,601销销售售月月报报表表序号品名销售量销售额1彩电2419,2002冰箱2517,4753电磁炉132,5874热水器8312,4505洗衣机21,5366空调3848,9447电脑87338,2568自行车549,0729手机7877,06410饮水机655,72011电扇572,73612吸尘器324,09613洗碗机152,82014缝纫机7414,65215电暖器681,904合计715558,512销销售售月月报报表表序号品名销售量销售额1彩电8568,0002冰箱4128,6593电磁炉265,1744热水器8412,6005洗衣机9472,1926空调2228,3367电脑831,1048自行车122,0169手机6463,23210饮水机141,23211电扇943212吸尘器698,83213洗碗机9117,10814缝纫机265,14815电暖器952,660合计740346,725
