We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

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...

1 Reply

AD Administrator Syncfusion Team August 2, 2004 12:48 PM

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"

Loader.
Live Chat Icon For mobile
Up arrow icon