Golf league form

Hi Ray22300,

I can help with this! You need a formula that automatically keeps 
only the last 3 scores for the  calculation.

Here's the solution:

You can use a combination of OFFSET and COUNTA to always reference 
the last 3 entries:

For the 3rd last score:
=IF(COUNTA($F$1:$AG$1)>=3,OFFSET($F$1,0,COUNTA($F$1:$AG$1)-3),"")

For the 2nd last score:
=IF(COUNTA($F$1:$AG$1)>=3,OFFSET($F$1,0,COUNTA($F$1:$AG$1)-2),"")

For the last score:
=IF(COUNTA($F$1:$AG$1)>=3,OFFSET($F$1,0,COUNTA($F$1:$AG$1)-1),"")

This will:
1. Count how many scores you have (COUNTA)
2. Always grab the last 3 scores
3. Auto-update as you add new weeks

For your specific case with f1, g1, h1, i1:
- Place this formula where you calculate 
- It will automatically use g1, h1, i1 (last 3) when you add i1

Best,
Korina