Help to correct a formula

[smoothpokerplyr]

I have a spreed sheet I setup for my golf league and I would like to get it to calculate the handicap for me based on the last three rounds. I can get it to work if I calculate with the scores going up an down but in my current spread sheet I put the scores going across I was hoping someone could help me correct the formula or give me another formula that would work to calculate the handicap. I have attached our normal spreed sheet and one I tested with the numbers going down. Any help would be greatly appreciated.

This the formula that works with scores going up and down

=ROUND((AVERAGE(OFFSET($B$2,COUNT(B2:B16)-3,0,3)))*3,0)/3-72

This one doesn't work with the scores going across the spread sheet

=ROUND((AVERAGE(OFFSET($D$2,COUNT(D3:R3)-3,0,3)))*3,0)/3-72

[brant.wheeler]

This should be your formula:

Please Login or Register  to view this content.

However, this will not work exactly right when the player was absent (ABS). I changed your "COUNT" to "COUNTA" to help with this, but a more complex solution is needed if you want to average the last 3 weeks that the player actually participated.

As a note: the original up and down formula you were using suffers from this same affliction.

[BlindAlley]

This is a handicap sheet that I found on line a long time ago when I was a bit of a golf fanatic. I do not claim it as mine but it works great.

[smoothpokerplyr]

That worked. but yes I never thought about if they were absent. Any ideas how to make that happen? Thanks so much for the help