Microsoft Office Tutorials and References
In Depth Information
Summing Stuff on Different Worksheets
Figure 7-11:
Book1
workbook after
moving a
copy of the
Sprat Diet
Ctr before
Sheet1.
Summing Stuff on Different Worksheets
I’d be remiss if I didn’t introduce you to the fascinating subject of creating
a summary worksheet that recaps or totals the values stored in a bunch of
other worksheets in the workbook.
The best way that I can show you how to create a summary worksheet is
to walk you through the procedure of making one (entitled Total Projected
Income) for the MGE – 2014 Projected Income workbook. This summary
worksheet totals the projected revenue and expenses for all the companies
that Mother Goose Enterprises operates.
Because the MGE – 2014 Projected Income workbook already contains nine
worksheets with the 2014 projected revenue and expenses for each one of
these companies, and because these worksheets are all laid out in the same
arrangement, creating this summary worksheet will be a breeze:
1. I insert a new worksheet in front of the other worksheets in the MGE –
2014 Projected Income workbook and rename its sheet tab from Sheet1
to Total Income.
Search JabSto ::




Custom Search