Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sum totals from mulitple worksheets
In Excel 2003 I have set up a workbook with multiple worksheets (one
worksheet per employee/week) that sums rows and columns. What I have been trying to do is have all of the sums from all of the worksheets read on another worksheet. I want to end up with a totals total page which I would call 'All Employees Total' . I want the data from each employee to be added to each other and read on the 'All Employees Total' page. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sum totals from mulitple worksheets
Add a sheet called First before the first employee, and one called Last
after the last employee, and then use =SUM(First:Last!H10) assuming H10 is your sum cell -- HTH Bob Phillips (remove nothere from email address if mailing direct) "unwizzed" wrote in message ... In Excel 2003 I have set up a workbook with multiple worksheets (one worksheet per employee/week) that sums rows and columns. What I have been trying to do is have all of the sums from all of the worksheets read on another worksheet. I want to end up with a totals total page which I would call 'All Employees Total' . I want the data from each employee to be added to each other and read on the 'All Employees Total' page. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summarizing totals of all worksheets to one worksheet? | Excel Worksheet Functions | |||
Formula for adding totals from separate worksheets | Excel Discussion (Misc queries) | |||
Transferring date from multiple worksheets to a "totals" worksheet. | Excel Discussion (Misc queries) | |||
Copying Numerical Totals of separate worksheets to a single Summary Worksheet | Excel Discussion (Misc queries) | |||
Copying Totals of separate worksheets to a single Summary Worksheet | Excel Discussion (Misc queries) |