Excel: Overtime Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 More

AutoSum

Most timesheets add across the row: that would calculate the weekly total for each Account. A timesheet also adds up the columns: the columns Sums the hours worked each day.

 

Select B13. That is the cell where we want to add up the numbers.

 

Click on AutoSum button on the Home Ribbon Editing Group. Excel fills in the formula: =SUM(B2:B12)

 

Use Enter or Tab on your keyboard to exit the equation.

 
Home ->Editing ->AutoSum

 

 

 

  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