Handicapping

[Golf.nut1]

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]

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))