If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
multi-worksheet sum
大家好!
如何对多工作表中符合行列的数据求和,谢谢! How to sum multiple sheets,thank! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
multi-worksheet sum
=SUM(Sheet1:Sheet3!A1:A10)
-- HTH Bob "无名" wrote in message ... 大家好! 如何对多工作表中符合行列的数据求和,谢谢! How to sum multiple sheets,thank! |
#4
|
|||
|
|||
multi-worksheet sum
拜肈琌ぃ琌㏕﹚竚,獶ミ砰そΑ秆∕,τ惠碝т –竚沮﹚嘿の腹―㎝,
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! EcoI?O?a1?⊙∫∮iODuoIDDADAEy?YCooI?D?D?! How to sum multiple sheets?thank! |
#5
|
|||
|
|||
multi-worksheet sum
建议... 与其对该公式费时间和努力,毋宁重新设计数据库。
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 -- MRT "无名" wrote in message ... 大家好! 如何对多工作表中符合行列的数据求和,谢谢! How to sum multiple sheets,thank! |
#6
|
|||
|
|||
multi-worksheet sum
用sum函数
"无名" 写入消息 ... 大家好! 如何对多工作表中符合行列的数据求和,谢谢! How to sum multiple sheets,thank! |
#7
|
|||
|
|||
multi-worksheet sum
It's conditional sumary.
Its anwser shoud be more complex. "Bob Phillips" ... =SUM(Sheet1:Sheet3!A1:A10) -- HTH Bob "无名" wrote in message ... 大家好! 如何对多工作表中符合行列的数据求和,谢谢! How to sum multiple sheets,thank! |
#8
|
|||
|
|||
multi-worksheet sum
牛,我是无名,新帆的无名。
说说公式吧,谢谢. |
#9
|
|||
|
|||
multi-worksheet sum
好难,在想**
"无名" ... 牛,我是无名,新帆的无名。 说说公式吧,谢谢. |
#10
|
|||
|
|||
multi-worksheet sum
如何用SUM
|
Thread Tools | |
Display Modes | |
|
|