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 <wa.two...@verizon.net.invalid> 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 semicolons =MINIFS(G6:G41;G6:G41;">0") rather > than commas; #NAME? error is returned. > > No joy here. > > I could not find anything as =MINFS( ) funtion within the built-in > (F1) Help file. Can you point me to a discussion elsewhere? > > > On 1/27/2020 3:01 PM, Alan B wrote: > > 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 desired in your example sheet. > > > > On Sun, Jan 26, 2020 at 2:40 PM WA.TWORSX via AOL > > <wa.two...@verizon.net.invalid> wrote: > > > >> 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: > >> > >> > >> > https://www.dropbox.com/s/05gk2h8zt7lbua2/Calc%20Help-updating%20Data_INTERIM%20SOLUTION.ods?dl=0 > >> > >> > >> The caveats and compromises are presented in the referenced .ods file by > >> way of annotated comments on the content of cells as used in my > solution. > >> > >> I am very appreciative to AlanB for the time he has spent in an effort > >> to lead me toward the correct Calc sheet. Believe me, I have learned > >> from his thoughtfulness and patience to explain why he made specific > >> suggestions for changing my approach. This is how I am able to learn. > >> Thank you Alan! If it were not for your assistance, I would not have > >> gotten to this point. > >> > >> In his 1/24/2020 posted reply, Alan mentioned a glitch involving cell > >> G36. I have not been able to duplicate the problem. > >> > >> Alan's logic for the formula in cell J6: > >> > >>> * The formula in cell J6 for "Total Pins" column calculates total pins > >> for > >>> rows 6 through row the formula is in. > >>> > >> > =IF(ISNUMBER(I6),DSUM($G$5:INDIRECT(CONCATENATE("$G",ROW())),1,$BB$5:$BB$6),"") > >>> This formula should be copied to all week# rows in column J. It updates > >>> correctly for each row it is in. > >> is far above my present skill level. Thus, I may return to it in the > >> future when I attempt to set up a calc sheet for a new WINTER SR LEAGUE > >> bowling season. > >> > >> Yes, this all started with my goal of AL7 and AN7 being updated > >> automatically, without first changing the enclosed formula or being > >> modified by hand. My interim solution allows for auto-updating of AL7. > >> Cell AN7 is simply: AN7=(AL7/3). > >> > >> Regards, > >> > >> VinceB. > >> > >> > >> P.S. The PBA Oklahoma Open Bowing Tournament stepladder finals are > >> presently being televised on FS1 channel. I'm gone! > >> > >> > >> > >> > >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > > -- Alan Boba CISSP, CCENT, ITIL v3 Foundations 2011
