multi-worksheet sum
 

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.


"ÎÞÃû" wrote:

´ó¼ÒºÃ£¡
ÈçºÎ¶Ô¶Ã*¹¤×÷±Ã*ÖÃ�·ûºÃ�Ã�Ã�Ã�Ã�µ ÄÊý¾Ã�ÇóºÃ�£¬Ã�»Ã�»£¡

How to sum multiple sheets£¬thank!

multi-worksheet sum
 

¥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)))


"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.


"ITAu" wrote:

¡¦o?OoA¢G!
EcoI?O?a1?¡Ñ¡Ò¡ÓiOD¡PuoIDDAD£gAEy?YCooI¢G?D?D?¢G!

How to sum multiple sheets¢G?thank!