In a golf league of 8-14 4-man teams handicaps reduce gross scores to net scores. A player who earns a net score 1 or 2 below par on a hole earns 1 or 2 points for that team. The league plays once per week and runs for several months. I wish to compute each player's point contribution each week on the ActiveWeek sheet, then accumulate his points to date...by hole...in columns G-X on the Names sheet. For example, Abraham has previously scored points as shown in Names!G3:X3. This week he got a 4 on hole #1, net 3, and this gives his team a point.
Question: How can I capture this information and accumulate it in cell Names!G3 such that the new answer is 2? Do that for everybody (who plays) each week.
Bookmarks