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 Bob's?
The disconnect comes with "using the results in [AL] and [AN]". How does a single row shown as 1 - 21 and columns [D] though [H] in your example relate to multiple individuals [AL] through [AN]? And more importantly, what are you trying to achieve? If I understood that I might be able to offer some useful help. On Sat, Jan 18, 2020 at 12:48 PM Vince@GMAIL <wa2rs...@gmail.com> wrote: > AOO 4.1.5 on Win10 Home desktop > > _________________________________ > > 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] [G] [H] <-------- Column headings > > */_Today is Week #_/* */_Today's Date Is_/* */_Game #1_/* */_Game #2 > _/* */_Game #3_/* */_Match Series_/* */_Match Average_/* > *1* 6-Sep 152 146 187 485 161.7 > *2* 13-Sep 133 159 141 433 144.3 > *3* 20-Sep 147 155 148 450 150.0 > *4* 27-Sep 161 151 142 454 151.3 > *5* 4-Oct 130 139 116 385 128.3 > *6* 11-Oct *Did Not Bowl. * > *7* 18-Oct 148 187 119 454 151.3 > *8* 25-Oct 155 167 169 491 163.7 > *9* 1-Nov 140 141 157 438 146.0 > *10* 8-Nov 147 135 155 437 145.7 > *11* 15-Nov 139 133 155 427 142.3 > *12* 22-Nov 164 162 164 490 163.3 > *13* 29-Nov 120 110 155 385 128.3 > *14* 6-Dec 150 136 125 411 137.0 > *15* 13-Dec 170 187 132 489 163.0 > *16* 20-Dec 160 168 146 474 158.0 > *17* 27-Dec 160 144 150 454 151.3 > *18* 3-Jan 151 141 138 430 143.3 > */_---Half Season---_/* > *19* 10-Jan *Did Not Bowl. * > *20* 17-Jan 161 134 147 442 147.3 > *21* 24-Jan > > > > > > I use the results generated in columns G and H in another section of the > sheet, as shown: > > [AL] [AN] <-------- Column headings > > *Team #2- ACHES & PAINS v2.0 > Post Match Play* > *Russ: * 458 *Player's Average: * 152.67 > *Vince: * 442 147.33 > *Dave: * 555 185.00 > *Bob: * 600 200.00 > > > Cells AL7 and AN7 are set to = the results calculated and provided > within cells G26 and H26, i.e., they show: 442 and 147.3. > > My problem is that after calculating an update result within columns G > and H, e.g., on 24 Jan, (week # 21's data), the results based on entry > of data in D27:F27, there will be new results in the next row, at cells > G27 and H27. Therefore, I am forced to manually change the formulae > within AL7 and AN7 to correctly reflect the updated results provided in > columns AL and AN, by changing =G26 to =G27 and by changing =H26 to =H27. > > Is there an easier method of handling this task, through use of a > function or a formula? > > I hope this is described clearly enough. If needed, I will attempt to > store the complete calc sheet at a Dropbox link. Let me know. > > Regards, > > VinceB. > > > -- Alan Boba CISSP, CCENT, ITIL v3 Foundations 2011