Microsoft Office Tutorials and References
In Depth Information
Creating Formulas to Add and Subtract Values
Creating Formulas to Add and Subtract Values
Next, you’ll work with the Monthly Sales worksheet, which contains the sales results by
month for the eight sales regions over the past two years. Tom wants to use this data to
identify trends. He’s more interested in the “big picture” than in specifi c numbers. He
wants to know which sales regions are performing well and which are underperforming.
He also wants to explore the pattern of monthly sales throughout the year.
Creating Formulas to Calculate Totals
The top of the worksheet contains annual sales for the previous two years. The bottom
of the worksheet displays the increase in annual sales for each region and month. Tom
wants you to calculate the monthly totals broken down by region. You’ll start with the
2011 sales values.
To calculate the monthly and regional totals for 2011:
1. Click the Monthly Sales sheet tab to make the worksheet active.
2. In cells K6 and B19, enter the label Total .
3. Select the nonadjacent range K7:K18;C19:K19 . You’ll add the formula to
calculate the total in these cells.
4. In the Editing group on the Home tab, click the Sum button . The 2011 monthly
and regional sales totals are entered in the selected range. See Figure 2-25.
Figure 2-25
Monthly and regional sales totals for 2011
Sum button
regional sa les totals
monthly s ales totals
Next, you will calculate the monthly and regional sales totals for 2012. Rather than
retyping the text and formulas, you can copy and paste them from 2011.
Search JabSto ::




Custom Search