adding named ranges
 

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

The correct syntax is
=SUM(range1,range2)

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Mike EHB-Docks" skrev i en meddelelse
...
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

"Leo Heuser" wrote in message
...
The correct syntax is
=SUM(range1,range2)

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Mike EHB-Docks" skrev i en meddelelse
...
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

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.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Mike W" skrev i en meddelelse
...
thanks Leo, works perfectly. What about other operators like subtraction
and division in these circumstances?

Mike

"Leo Heuser" wrote in message
...
The correct syntax is
=SUM(range1,range2)

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Mike EHB-Docks" skrev i en meddelelse
...
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

=range1+range2 add
=range1-range2 subtract
=range1*range2 multiply
=range1/range2 divide
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mike EHB-Docks" wrote in message
...
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

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

"Bernard Liengme" wrote in message
...
=range1+range2 add
=range1-range2 subtract
=range1*range2 multiply
=range1/range2 divide
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mike EHB-Docks" wrote in message
...
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

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
"Mike W" wrote in message
...
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

"Bernard Liengme" wrote in message
...
=range1+range2 add
=range1-range2 subtract
=range1*range2 multiply
=range1/range2 divide
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mike EHB-Docks" wrote in message
...
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

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mike W" wrote in message
...
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
"Mike W" wrote in message
...
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

"Bernard Liengme" wrote in message
...
=range1+range2 add
=range1-range2 subtract
=range1*range2 multiply
=range1/range2 divide
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mike EHB-Docks" wrote in message
...
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