| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Add a range from elsewhere
Hi,
Could someone please advise how to draw in a named range from another sheet? Something like this: =SUM(Rng1,Rng2,Rng3,'Sheet2'!OtherRng9) where the "other" range come from another sheet in the same workbook. I'm having trouble with this one. Thanks |
|
#2
|
|||
|
|||
|
Hi
you should just be able to use =SUM(Rng1,Rng2,Rng3,OtherRng9) Cheers JulieD "Arnie" wrote in message ... Hi, Could someone please advise how to draw in a named range from another sheet? Something like this: =SUM(Rng1,Rng2,Rng3,'Sheet2'!OtherRng9) where the "other" range come from another sheet in the same workbook. I'm having trouble with this one. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
| Defined range difficulty | Excel Discussion (Misc queries) | |||
| named range refers to: in a chart | Excel Discussion (Misc queries) | |||
| range names | Excel Worksheet Functions | |||
| range names | Excel Worksheet Functions | |||
Hybrid Mode
