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