Microsoft Office Tutorials and References
In Depth Information
Chapter 19: Multi-Page Budgets—Going to the Third Dimension
The next part is to enter the hours worked for each one of the five weeks. This
data is displayed in Figure 19.5. As you enter the hours worked, the formulas will
calculate the salaries and the totals for each one of the individual weeks.
You have to sum the Hours of the first employee, Vincenzo Alfano, for all five
weeks into the totals sheet. The significant part of this sum is
through all five sheets and summing the information on the last sheet, named the
totals sheet. See Figure 19.6.
What you want to do is to select cell D2 on the totals sheet and sum the hours
worked for Vincenzo Alfano from all the others, the five individual weeks
After you select the cell D2, click on the Auto-sum icon
. Next, click on the
Week1 sheet tab. Your formula bar will read
SUM(Week1!). Next, press Shift
click on the Week5 sheet tab.
Your formula bar will read
SUM(Week1:Week5!). This indicates that you are
going to sum the values from week1 to week5. The only thing that is left to do is
select the cell where you want the result to appear, namely cell D2 on the Totals
sheet. Click on D2 and the formula bar will read
you hit Enter, you will get the desired sum; the sum of the total number of hours Mr.
Alfano worked for the five weeks. It should be 142.00. The salary is computed
automatically for the entire month. See Figure 19.7.
FIGURE 19.4 Sum of All Salaries
FIGURE 19.5 The Five Weeks ’ Payrolls