| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
question
How do I do a 3-D cell reference?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
question
=SUM('Sheet1:Sheet3'!A1)
will total cell A1 on Sheet1 through Sheet3. Some of the experts recommend inserting a sheet named Start and one named End before and after the sheets you want included in the 3d formula (for reference and you don't need to modify your formula if you add/move/delete sheets. "kim010981" wrote: How do I do a 3-D cell reference? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possibly a loaded question, but I think | Excel Discussion (Misc queries) | |||
| How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
| Newbie With A Question | Excel Worksheet Functions | |||
| Anybody Help with previous question | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Linear Mode
