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

vertically

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

“

drilling

”

’

sheets.

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

¼

SUM(Week1:Week5!D2). When

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