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
close icon

Using formulas and indexed ranges

Hello,

I'm trying to insert a formula in a cell, based on indexed ranges. I.e. I know i need the sum of the range (3,5) to (3,7), but how do I translate that into Excel ranges ?

1 Reply

BV Bert Vanpeteghem October 11, 2007 12:39 PM UTC

Answering my own noob question:

AddressLocal property of a Range

>Hello,

I'm trying to insert a formula in a cell, based on indexed ranges. I.e. I know i need the sum of the range (3,5) to (3,7), but how do I translate that into Excel ranges ?

Loader.
Live Chat Icon For mobile
Up arrow icon