Forum Discussion

Anonymous's avatar
Anonymous
Oct 05, 2023

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...
Formulas and Functions
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Oct 05, 2023

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.

Resources