adding named ranges

  • Thread starter Thread starter Mike EHB-Docks
  • Start date Start date
M

Mike EHB-Docks

I have two ranges of cells named range1 and range2 but I am unable to add
them together as =sum(range1+range2) gives me an error

Any help would be appreciated.

Mike
 
thanks Leo, works perfectly. What about other operators like subtraction
and division in these circumstances?

Mike
 
You're welcome, Mike :-)

About the other operators:
It depends on, what you're trying to accomplish.
Which cells are to be subtracted, which cells
divided?
Please forward an example.
 
=range1+range2 add
=range1-range2 subtract
=range1*range2 multiply
=range1/range2 divide
 
Hi Bernard, that doesn't seem to work for me.

I have tried the following =sum(range1*range2) and =sum(range1)*(range2)
and just about every variation I can think of but always end up with an
error.

thanks to all,

Mike
 
I've got it. They say when the pupil is ready the teacher appears and so it
was here. Someone came into my office and asked what I was trying to do. I
told him and he showed me how to do it. =SUM(range1)-SUM(range2)
Brilliant, and works with all operators.

Thanks all for you help.

Mike
 
The problem was the use of the term "named" in the original question.
To Excellers this has a special meaning: that the range has been given a
name in Excel.
best wishes
 
Back
Top