How to use AverageIF to average the last 5 scores for a player in a range

[analyst11]

Hi everybody. I have a table of data that tracks scores for players on a team. the data is separated by dates. how would I use the AverageIF function to average the last 5 scores for a player from the data set? thanks

 

[Aladin Akyurek]

Care to post a sample of 8 rows along with the expected result?