|
This timesheet will calculate the daily total. For example, how many hours
did you work on Monday? 5.
Try it: AutoSum the Data Select
Cell A13. Go to
Formulas ->AutoSum
->Sum. What Do
You See? The formula in Cell A13 is =SUBTOTAL(109,[Monday]) What
Else Do You See? The AutoCorrect options allows you to select
the following: Place
Formula in Table Total Row Place
Formula Inside Table Place
Formula Below Table. Pick
Place Formula in Table Total Row. Keep
going...!
Memo to Self: You may have
been expecting a formula that looked like this:
=SUM(A2:A12).
This is a Table, so the function is
different.
Formulas ->AutoSum
->Sum
Exam 77-882: Microsoft Excel 2010
Core
5. Applying Formulas and Functions
5.1. Create formulas |
|
| |
