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

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