formula for golf league

  • Thread starter Thread starter picktr
  • Start date Start date
P

picktr

I need a formula that will automaticaly
update handicaps using the last three
scores entered.

ex: A1 B1 C1 D1 E1 formula

35 32 38
 
using the last three
scores entered.

ex: A1 B1 C1 D1 E1 formula

35 32 38 ?? <g>
Click to expand...

What are you playing Crazy Golf?

To add up the last three scores in row 1 try:

=SUM(OFFSET(A1,0,COUNT(1:1)-3):OFFSET(A1,0,COUNT(1:1)))

Assumes that there are no spaces in the data

HTH

Sandy
 
CELL REF STARTS AT K3 AND CONTINUES TO Z3
OUTPUT CELL IS B3

WHEN I ENTER WK6 RESULTS INTO P3, IT SHOULD
ONLY AVG THE NUMBERS IN P3, O3, N3

AT THE END OF THE SEASON, WHEN I ENTER THE LAST SCORE IN
Z3 IT SHOULD ONLY AVG THE NUMBERS IN Z3, Y3, X3

HOW DO I CHANGE THIS:
=SUM(OFFSET(A1,0,COUNT(1:1)-3):OFFSET(A1,0,COUNT(1:1)))

TO REFLECT:
AVG OF LAST 3 CELLS FILLED

ACTUALLY THE FORMULA FOR HDCP IS
((SUM OF LAST THREE GAMES / 3) - 72) * 0.80

PLEASE EMAIL - (e-mail address removed)
 
THE FORMULA TO COMPUTE MY HANDICAP IS:

((AVERAGE(G3:I3))-35)*.80

NOW THE FUN PART.

THAT FORMULA IS FIXED, I NEED IT TO CONSTANTLY CHANGE
AND ONLY CALCULATE THE LAST 3 SCORES ENTERED.

WHEN I ENTER A SCORE INTO J3 IT SHOULD AUTOMATICALLY
CHANGE THE FORMULA TO (H3:J3) -

I HOPE THIS HELPS.

(e-mail address removed)
 
Using all caps is considered rude since it is the equivalent of shouting

=AVERAGE(Z3:INDEX(3:3,LARGE(COLUMN(K3:Z3)*(K3:Z3<>""),3)))

entered with ctrl + shift & enter

will give you the average
 
Back
Top