See David Robeley's response.
I was jumping back and forth between virtual machines and inadvertently
used the one with LibreOffice without remembering you're using OpenOffice.
My bad.
Sorry about that.
On Mon, Jan 27, 2020 at 4:20 PM WA.TWORSX via AOL
wrote:
> Alan:
>
> I tried in cell H44:
TNX David; I have just been visiting the LibreOffice help
https://help.libreoffice.org/6.2/he/text/scalc/01/func_minifs.html?DbPAR=CALC
and came to that same conclusion.
On 1/27/2020 4:46 PM, David Robley wrote:
Those functions are not available in AOO - but exist in LibreOffice
since
Those functions are not available in AOO - but exist in LibreOffice
since around version 5.2
On 28/1/20 7:50 am, WA.TWORSX via AOL wrote:
Alan:
I tried in cell H44: =MINIFS(G6:G41,G6:G41,">0"), but it is not
working for me. Error508: Error in bracketing is shown.
I also tried with use of
Alan:
I tried in cell H44: =MINIFS(G6:G41,G6:G41,">0"), but it is not working
for me. Error508: Error in bracketing is shown.
I also tried with use of semicolons =MINIFS(G6:G41;G6:G41;">0") rather
than commas; #NAME? error is returned.
No joy here.
I could not find anything as =MINFS( )
Hello Vince,
Thank you for your kind words.
In your sheet notes you describe needing to "segment a formula" into
several ranges. Unnecessary work, I think.
Try the following formulas instead...
In H43, =MAXIFS(G6:G41,G6:G41,">0")
In H44, =MINIFS(G6:G41,G6:G41,">0")
They appear to me to work as
I believe that I am successful with an interim solution to my original
problem.
This DropBox link, I think, will allow you to download my interim
solution, which comes with some caveats and compromises:
And, here I was about to claim that I have a satisfactory *work-around
solution*, including cell AL7, and was about to incorporate the changes
into my actual .ods file that is being used for the present bowling
season. I'll come up with a DropBox link to what I think is a workable
solution,
DNB is meant to note someone did not bowl. It is just text entered in each
cell rather than merging the cells and entering "Did not bowl".
Now, some bad news. After reviewing what I suggested I realized the formula
given for cell AL7 will always show the value in G36 if the column G
formula is
Ooops!
DNB=Did not Bowl.
I am presently troubleshooting why the result at cell AL7 (i.e.,
=INDEX($Sheet1.G6:G42,COUNTA($Sheet1.G6:G42),1) is not correct.
The difference between COUNT and COUNTA is yet to sink into this
author's gray matter.
On 1/24/2020 10:16 AM, WA.TWORSX via AOL wrote:
On 1/20/2020 5:58 PM, Alan B wrote:
I've found a method that can work, providing the spreadsheet design is
modified somewhat.
It comes from a formula provided by RusselB in the OpenOffice forums.
=index(range;count(range);1)
For your sample spreadsheet this formula in cell AL7
I tested by modifying the formula in cell H7 in your sample spreadsheet.
The modified formula is...
=IF((ISNUMBER(G7));(G7/3);"")
The test is whether or not the value in G7 is a number, ISNUMBER(G7). Text
or a blank returns false, any number returns true. Replace the existing
formula in column H
Hi Alan:
I am trying to work my way through your suggestions. Changes to satisfy
Design Change Requirements #1 and #3 are not a problem.
However, Required Design Change #2 is problematic for me. :-[
I am not successful with IF-testing in the Match Average and Total Pins
columns to satisfy
I've found a method that can work, providing the spreadsheet design is
modified somewhat.
It comes from a formula provided by RusselB in the OpenOffice forums.
=index(range;count(range);1)
For your sample spreadsheet this formula in cell AL7
=INDEX($Sheet1.G6:G42,COUNTA($Sheet1.G6:G42),1)
will
Hello Alan B:
TNX for reading my query about Calc Help-updating Data.ods.
For reasons, unknown to me, my pasted example seems to be
plain/unformatted text, although I had sent it out via Mozilla
Thunderbird email client using both HTML and plain text to the AOO
mailing list, and appeared
Hello Vince,
I'm intrigued but not able to follow what you're trying to do. Columns D
through H appear to be the games bowled in any given week, rows (or should
I say weeks) 1 through 21 are the results of the games in those weeks. That
seems clear to me. But whose games, Russ, Vince, Dave, or
At 11:55 18/01/2020 -0500, Vince Bonly wrote:
Note: Cells with a yellow background identify required data must be
entered. Cells with a (darker) gray background identify cells which
show calculated results.
I have a Calc sheet that I enter data on a regular basis, as shown below:
[D] [E] [F]
16 matches
Mail list logo
