3DReferences

# 3DReferences - referenced All the worksheets between the...

This preview shows pages 1–4. Sign up to view the full content.

5c155a010be5287523fb526f5be7ab2e39a71a56.xls Introduction Notes on 3-D References A 3-D reference is an Excel cell or range reference preceded by a range  of worksheet names. Excel uses any worksheets stored between the  starting and ending names of the reference. For example,  =SUM(Sheet2:Sheet14!B5) adds all the values contained in cell B5  on all the worksheets between and including Sheet 2 and Sheet 14. Use 3-D references to: SUM, AVERAGE, AVERAGEA, COUNT, COUNTA, MAX,  MAXA, MIN, MINA, PRODUCT, STDEV, STDEVA,  STDEVP, STDEVPA, VAR, VARA, VARP, and VARPA. To create a 3-D reference: 1. Click the cell in which you want to enter the function. 2. Type an equal sign, the name of the function, and an open parenthesis. 3. Click the worksheet tab for the first worksheet to be referenced.  Hold down SHIFT and click the tab for the last worksheet to be

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: referenced. All the worksheets between the first and last (if any) will also automatically be selected. 4. Select the cell or range of cells to be referenced in the function you’re using. 5. Complete the formula. Examples See the three worksheets that follow for illustrations. • refer to cells on other sheets • define names • create formulas using the functions listed below 5c155a010be5287523fb526f5be7ab2e39a71a56.xls First 100 Refer to cells on other sheets: Result 700 Formula =SUM(First:Third!A2) Define names: Name cells on multiple sheets: 15 Result 56 Formula =SUM(ThreeCellsatA11) A B C D E F 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 5c155a010be5287523fb526f5be7ab2e39a71a56.xls Second 100 19 A 1 2 3 4 5 6 7 8 9 10 11 5c155a010be5287523fb526f5be7ab2e39a71a56.xls Third 500 22 A 1 2 3 4 5 6 7 8 9 10 11...
View Full Document

{[ snackBarMessage ]}

### Page1 / 4

3DReferences - referenced All the worksheets between the...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online