View Single Post
  #1   Report Post  
Arnie
 
Posts: n/a
Default 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