Il 08/02/2011 18:02, Johnny Rosenberg ha scritto: > What I want is a cell function like ADDRESS(), but instead of a > reference to a single cell, I want a reference to a cell range. > > ADDRESS(1;1;1) ⇨ $A$1 > ADDRESS(2;2;4) ⇨ B2 > > I would like something like this: > > RANGEADDRESS(1;1;1;2;2;4) ⇨ $A$1:B2 > > Can't find such a function, though. What do I miss? > > Can I use ADDRESS() in some combination to obtain this anyway? > > Here is a quick example of what I'd like to do: > =SUM(RANGEADDRESS(A1;B1;C1;D1;E1;F1)) > try this: ADDRESS(1;1;1)&":"&ADDRESS(2;1;1) > $A$1:$A$2
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
