Excel: It All Adds Up Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
 
Home -> Editing ->AutoSum

 

AutoSum

How Much Does It Cost?

1. Calculate the Wholesale Cost

AutoSum fills in the equation: =Sum(B2:B5). In real words, that means: add up all the numbers in cell B2 through B5 for the apples, basket, bow and box.

 

Now, look on the Home Ribbon for the Sum button. It looks like the Greek letter S, or sigma. When you roll your mouse over the toolbar, the tool tip says, “Sum.”

 

Try it: Select cell B6

Click on AutoSum.

Click on the Enter key on your keyboard to see the results. Excel won’t calculate until you leave the cell.

 

The wholesale price should be $8.50.

2. Calculate the Retail Cost

Select D6, and then click on the AutoSum button. Did you get $12.75?


OK, you get the cookie.