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: