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! > > > > > -- Alan Boba CISSP, CCENT, ITIL v3 Foundations 2011
