Excel: A Question of Balance Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 More
 
Formulas->AutoSum ->Sum

 

Calculate the SUM

The next examples demonstrate  the AutoSum Functions.

 

Try it: AutoSum the Salaries

Select Cell D5.

Go to Formulas-> AutoSum.

Click on Sum.

 

 

What Do You See? Microsoft Excel created an equation in Cell D5: =SUM(D2:D4)

 

 

  Microsoft Excel 2007 Exam 77-602 Topic: 3. Creating and Modifying Formulas

  3.2. Summarize data using a formula  3.2.1.  Use SUM, COUNT, COUNTA, AVERAGE, MIN, and MAX