Averaging in Excel

[Deleted]

I am a bowler and am trying to set up an Excel spreadsheet to automatically total my three games each Wednesday and then get my average from those 3 games plus all other games I have bowled so far this year. I know how to complete this by adding the formula manually. I want to know how to set it up to complete the totaling and averaging automatically after I enter my scores to the spreadsheet.

[#2]

@Deleted 

=AVERAGE(INDEX(2:4,,COUNTA(2:2)))

=AVERAGE(INDEX(2:4,,1):INDEX(2:4,,COUNTA(2:2)))

You can try these formulas. Enter the formulas with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021. The first formula is for the average of the latest results, the second formula for all results so far.