G
Guest
I want to construct ranges using the address function, but it comes out
invalid. An example is
sum (address(4,2,1):address(20,2,1))
or
sum (address(e7,2,1):address(e8,2,1))
but I keep getting that this is invalid.
The general idea is to be able to use another cell to tell me where a range
begins and ends. I was able to do this years ago in 123, but excel has
trouble with it.
How can I accomplish this?
invalid. An example is
sum (address(4,2,1):address(20,2,1))
or
sum (address(e7,2,1):address(e8,2,1))
but I keep getting that this is invalid.
The general idea is to be able to use another cell to tell me where a range
begins and ends. I was able to do this years ago in 123, but excel has
trouble with it.
How can I accomplish this?