I was meaning that if I have 10 sheets, I can refer to them by position
1 to 10 rather than by name.
=SHEET($Sheet19.B28) returns 29. I was wondering if I could refer to
this cell something like ='29'.B28
On 18/03/2023 22:20, ady wrote:
If by "sheets by position" you mean things like "the next
If by "sheets by position" you mean things like "the next one,
whichever the next worksheet would be", you can. I don't know whether
you actually need this feature – please allow me to doubt it – but
there is such a thing in LibreOffice Calc.
Beware: if you need compatibility with other
On 17/03/2023 13:08, Michael D. Setzer II wrote:
On 16 Mar 2023 at 23:29, Regina Henschel wrote:
Subject:Re: [libreoffice-users] Function acting on
range
To: users@global.libreoffice.org
From: Regina Henschel
Date sent: Thu
> > ISTM that using SUM() and COUNT() would be simpler, if the data is
> > already with the layout as described, in multiple sheets.
> Don't see how just using SUM() and COUNT() would work. Assuming the use of
> ABS was wanting to change negative values to positive values a simple sum of
>
On 16 Mar 2023 at 23:29, Regina Henschel wrote:
Subject:Re: [libreoffice-users] Function acting on
range
To: users@global.libreoffice.org
From: Regina Henschel
Date sent: Thu, 16 Mar 2023 23:29:10 +0100
> Hi Mich
, Regina Henschel wrote:
Hi Michael,
Michael D. Setzer II schrieb am 16.03.2023 um 22:45:
On 16 Mar 2023 at 18:22, ady wrote:
From:ady
Date sent:Thu, 16 Mar 2023 18:22:56 -0300
Subject:Re: [libreoffice-users] Function acting on
range
To:Users
Hi Regina,
But you can use {=AVERAGE({ABS($Sheet1
Hi Michael,
Michael D. Setzer II schrieb am 16.03.2023 um 22:45:
On 16 Mar 2023 at 18:22, ady wrote:
From:ady
Date sent:Thu, 16 Mar 2023 18:22:56 -0300
Subject:Re: [libreoffice-users] Function acting on
range
To:Users
Hi Regina,
But you can use {=AVERAGE({ABS($Sheet1.B1:$Sheet1.B30
On 16 Mar 2023 at 18:22, ady wrote:
From:ady
Date sent:Thu, 16 Mar 2023 18:22:56 -0300
Subject:Re: [libreoffice-users] Function acting on
range
To:Users
> Hi Regina,
>
> > But you can use {=AVERAGE({ABS($Sheet1.B1:$Sheet1.B30)} for example.
>
> Besides the typo, for tha
I was able to accomplish array math by clicking on the fx button on the row
above the letters naming columns, then click the array checkbox in the
lower left of the function wizard dialog box.
After that the function listing shows {} around the function, but you can't
type that in to get the
Hi Regina,
> But you can use {=AVERAGE({ABS($Sheet1.B1:$Sheet1.B30)} for example.
Besides the typo, for that to work it would need to be all in the same
worksheet, which is contrary to the initial setup.
ISTM that using SUM() and COUNT() would be simpler, if the data is
already with the layout
Two separate issues.
A_ The curly brackets are not to be introduced manually. They are only
a sign that the formula is not "normal" (as introduced by pressing
[ENTER]) but instead is an array formula, introduced by simultaneously
pressing [CTRL]+[SHIFT]+[ENTER] (CSE). Search the wiki or the web
Hi Steve,
Steve Edmonds schrieb am 16.03.2023 um 21:37:
On 16/03/2023 23:12, Regina Henschel wrote:
Hi Steve,
Steve Edmonds schrieb am 16.03.2023 um 01:13:
Hi, on the off chance I will be pleasantly surprised, can a function
act on a range.
i.e can I do something like
On 16/03/2023 23:12, Regina Henschel wrote:
Hi Steve,
Steve Edmonds schrieb am 16.03.2023 um 01:13:
Hi, on the off chance I will be pleasantly surprised, can a function
act on a range.
i.e can I do something like =AVERAGE(ABS($Sheet1.B28:$Sheet19.B28))
to average the absolute value of the
Hi Steve,
Steve Edmonds schrieb am 16.03.2023 um 01:13:
Hi, on the off chance I will be pleasantly surprised, can a function act
on a range.
i.e can I do something like =AVERAGE(ABS($Sheet1.B28:$Sheet19.B28)) to
average the absolute value of the numbers in the range.
The above seems to
On 16 Mar 2023 at 13:13, Steve Edmonds wrote:
Date sent: Thu, 16 Mar 2023 13:13:03 +1300
To: Users
From: Steve Edmonds
Subject:[libreoffice-users] Function acting on range
> Hi, on the off chance I will be pleasantly surpri
Hi, on the off chance I will be pleasantly surprised, can a function act
on a range.
i.e can I do something like =AVERAGE(ABS($Sheet1.B28:$Sheet19.B28)) to
average the absolute value of the numbers in the range.
The above seems to return only the last value of the range. I can
achieve this
16 matches
Mail list logo