multi-worksheet sum

[trip_to_tokyo]

In EXCEL 2007 in order to extract and sum data on a specific page of the
Workbook:-

1. Assume I have a Workbook set up in which there are 4 Worksheets and I
wish to sum cell C6 from 3 of those Worksheets in Sheet1.

2. In cell C6 of Sheet1 (this is where I want the total to appear):-

Home / Editing group / AutoSum / Sum

3. Now click on the first Worksheet you wish to include in the total and
click in cell C6.

4. Hold down the SHIFT key and click on the tab of the last (furthest to the
right) Worksheet whose cell C6 you wish to include in the total.

Release the SHIFT KEY.

5. Now hit the tick (check) to the left of the fx button to the left of the
Formula bar.

6. You will now have the total of cell C6 in Sheet1 where the formula is:-

=SUM(Sheet2:Sheet4!C6)

Please hit Yes if my comments have helped.

Thanks.

´ó¼ÒºÃ£¡
ÈçºÎ¶Ô¶à¹¤×÷±íÖзûºÏÐÐÁеÄÊý¾ÝÇóºÍ£¬Ð»Ð»£¡
How to sum multiple sheets£¬thank!

[Bob Phillips]

=SUM(Sheet1:Sheet3!A1:A10)

[°ëÊìÅ£]

It's conditional sumary.
Its anwser shoud be more complex.

Post by Bob Phillips
=SUM(Sheet1:Sheet3!A1:A10)
--
HTH
Bob

ŽóŒÒºÃ£¡
ÈçºÎ¶Ô¶à¹€×÷±íÖзûºÏÐÐÁеÄÊýŸÝÇóºÍ£¬Ð»Ð»£¡
How to sum multiple sheets£¬thank!

[ÎÞÃû]

Å££¬ÎÒÊÇÎÞÃû£¬Ð·«µÄÎÞÃû¡£
˵˵¹«Êœ°É£¬Ð»Ð».

[°ëÊìÅ£]

ºÃÄÑ£¬ÔÚÏë¡­¡­

Post by ÎÞÃû
Å££¬ÎÒÊÇÎÞÃû£¬Ð·«µÄÎÞÃû¡£
˵˵¹«Êœ°É£¬Ð»Ð».

[ªá¥Ò¯Î]

¥Lªº°ÝÃD¬O€£¬O©T©wªºŠìžm,«D¥ßÅ逜Š¡¥ižÑšM,ŠÓ»ÝŽM§äšCªíªºŠìžm®ÚŸÚ«ü©wŠWºÙ€Î«¬ž¹šD©M,
b2=SUM(INDEX('1'!$B$2:$D$5,MATCH($A2,'1'!$A$2:$A$5,0),MATCH(B$1,'1'!$B$1:$D$1,0)),INDEX('2'!$B$2:$D$5,MATCH($A2,'2'!$A$2:$A$5,0),MATCH(B$1,'2'!$B$1:$D$1,0)),INDEX('3'!$B$2:$D$5,MATCH($A2,'3'!$A$2:$A$5,0),MATCH(B$1,'3'!$B$1:$D$1,0)),INDEX('4'!$B$2:$D$5,MATCH($A2,'4'!$A$2:$A$5,0),MATCH(B$1,'4'!$B$1:$D$1,0)),INDEX('5'!$B$2:$D$5,MATCH($A2,'5'!$A$2:$A$5,0),MATCH(B$1,'5'!$B$1:$D$1,0)))

Post by trip_to_tokyo
In EXCEL 2007 in order to extract and sum data on a specific page of the
Workbook:-
1. Assume I have a Workbook set up in which there are 4 Worksheets and I
wish to sum cell C6 from 3 of those Worksheets in Sheet1.
2. In cell C6 of Sheet1 (this is where I want the total to appear):-
Home / Editing group / AutoSum / Sum
3. Now click on the first Worksheet you wish to include in the total and
click in cell C6.
4. Hold down the SHIFT key and click on the tab of the last (furthest to the
right) Worksheet whose cell C6 you wish to include in the total.
Release the SHIFT KEY.
5. Now hit the tick (check) to the left of the fx button to the left of the
Formula bar.
6. You will now have the total of cell C6 in Sheet1 where the formula is:-
=SUM(Sheet2:Sheet4!C6)
Please hit Yes if my comments have helped.
Thanks.

¡Šo?OoA¢G!
EcoI?O?a1?¡Ñ¡Ò¡ÓiOD¡PuoIDDAD£gAEy?YCooI¢G?D?D?¢G!
How to sum multiple sheets¢G?thank!

[MRT]

œšÒé... ÓëÆä¶ÔžÃ¹«Êœ·ÑʱŒäºÍŬÁŠ£¬ÎãÄþÖØÐÂÉèŒÆÊýŸÝ¿â¡£

You are recommended to remake the database design
than investing a good deal of time and effort to make that formula.

Group(sheet) name type qty.
1 D 20*40 4
3 B 20*50 2
2 C 20*60 3
5 C 20*50 3
4 A 20*40 1

[houninghn]

用sum函数

大家好！
如何对多工作表中符合行列的数据求和，谢谢！
How to sum multiple sheets，thank!

[ÎÞÃû]

ÈçºÎÓÃSUM