Add range to a span of cells

Hi , I''ve looked at the example about Namming the range. It is more like one name Range for a Cell, is the any way I can set for a span of cells. for example Range1 = "C1:C10" Range2 = "D1:D10" Range3 = "E1:E10" then late on use Range3 = Range1 + Range2 (this is just an example, the syntax might be different) internally, the values gonna be something like this Range3[1] = Range1[1] + Range2[1] ... ... ... ... ... Range3[10] = Range1[10] + Range2[10] Thank you. Huy Le...

I assume you are looking at some private build as Named Ranged support has not been released publicly yet, is this correct? Anyway, you cannot do Range3 = Range1 + Range2 but you can have a formula in a cell that reads = Sum(Range1) + Sum(Range2) when you define range1 = "C1:C10" and range2 = "D1:D10"