Microsoft Office Tutorials and References
In Depth Information
Summing Stuff on Different Worksheets
Figure 7-12:
The Total
Income
worksheet
after I
create a SUM
formula
to total
projected
revenues
for all the
Mother
Goose
companies.
If you want to select the same cell across multiple worksheets, you can press
and hold the Shift key, and then select the last worksheet. All worksheets in
between the first and last will be included in the selection, or in this case, the
calculation.
All that’s left to do now is to use AutoFill to copy the master formula in cell
B3 down to row 22 as follows:
1. With cell B3 still selected, I drag the AutoFill handle in the lower-right
corner of cell B3 down to cell B22 to copy the formula for summing the
values for the nine companies down this column.
2. Then I delete the SUM formulas from cells B4, B12, B14, B15, and B19 (all
of which contain zeros because these cells have no income or expenses
to total).
In Figure 7-13, you see the first section of the summary Total Income worksheet
after I copy the formula created in cell B3 and after I delete the formulas from
the cells that should be blank (all those that came up 0 in column B).
Search JabSto ::




Custom Search