Handicapping

Golf.nut1 · May 6, 2004

I would like to make up a spreadsheet for golf handicaps
where only the last 3 scored entered in a row are
counted. Do you know how I can do this?

Frank Kabel · May 6, 2004

Hi
if you don't have blanks use the following to sum the last three values
of row 2:
=SUM(OFFSET($A2,0,COUNTA(2:2)-1,1,-3))