AutoSum the Total Sales

What is the sum of all the products sold?  Here are the steps to calculate the total sales.

 

Try it: AutoSum the Revenue

Select Cell E21

Go to Home ->Editing->AutoSum.

 

Excel will enter the formula:

=SUM(E2:E20)

 

Click ENTER on your keyboard.

 

What Do You See? In the example on this page the Sum is $4,132.50.

Home ->Editing->AutoSum

 

Exam 77-882: Microsoft Excel 2010 Core

5. Applying Formulas and Functions

5.1. Create formulas: Use SUM, COUNT, COUNTA, AVERAGE, MIN, and MAX