This
equation will link the Summary sheet to each of the product sheets:
Legs, Eggs, and Pigs. Try it:
Create reference links 1. Start on
the Summary Sheet Select
Cell C2 type: =. All good equations begin
with "=" 2. Go to the
Legs sheet Select Cell E2. Type + (to
add the next variable) 3. Go to the
Eggs sheet Select Cell E2. Type + (to
add the next variable) Keep
going, please...
Exam 77-882: Microsoft Excel 2010
Core
5. Applying Formulas and Functions
5.3. Apply cell references in
formulas: Reference data from other worksheets or workbooks
|
|
| |
