adding named ranges

[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

 

[Leo Heuser]

The correct syntax is
=SUM(range1,range2)

 

[Mike W]

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

Mike

 

[Leo Heuser]

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.

 

[Bernard Liengme]

=range1+range2 add
=range1-range2 subtract
=range1*range2 multiply
=range1/range2 divide

 

[Mike W]

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

 

[Mike W]

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

 

[Bernard Liengme]

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