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