yogi_For Golf Handicap SumUp Score For Specified Number Of Last Games Played

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

rdwestny said:
To calculate handicaps, I need a formula to sum the last five golf scores of league member to calculate handicaps. In the example below, I need to sum Player X's last five games, which were played on 07/07/11, 06/16/07, 06/09/11, 05/26/11, and 05/12/11.
Date Player X
04/14/11 80
04/21/11 70
05/05/11
05/12/11 65
05/19/11
05/26/11 82
06/02/11
06/09/11 75
06/16/11 78
06/23/11
06/30/11
07/07/11 80
-------------------------------------------------------------------------
here we go ...