Il 08/02/2011 22:54, Johnny Rosenberg ha scritto: > Den 2011-02-08 20:58:16 skrev yahoo-pier_andreit <pier_andr...@yahoo.it>: > >> 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 > > Well, I'm not looking for only displaying an address, I want to use it > for something, for example > =SUM(ADDRESS(1;1;1)&":"&ADDRESS(2;1;1)) > doesn't work. > > try this: =SUM(indirect(ADDRESS(1;1;1)&":"&ADDRESS(2;1;1)))
--------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
