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