My cursor keeps jumping from location to location while typing without any
prompting from me. Might you direct me to where I might get some help for a
correction!
-----Original Message-----
From: yahoo-pier_andreit
Sent: Wednesday, February 09, 2011 4:32 AM
To: [email protected]
Subject: Re: [users] OpenOffice.org Calc: Can't find a cell function that
returns a cell range.
Il 08/02/2011 22:54, Johnny Rosenberg ha scritto:
Den 2011-02-08 20:58:16 skrev yahoo-pier_andreit <[email protected]>:
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: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
