Add a range from elsewhere

  • Thread starter Thread starter Arnie
  • Start date Start date
A

Arnie

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Script help 4
Just a quick thank 1
Split list query for Vlookups 1
Select range from a varaible 5
Locate non-blanks in a column and copy certain data from the row 1
How to copy specific columns until end of data 1
Dependent drop down dynamic range formula, off sheet. 7
I have a rng problem 2

Back
Top