Forum Discussion
Averaging in Excel
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 th...
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.