Good afternoon. I am relatively inexperienced with Excel, but am tasked to create a spreadsheet in which the goal is to have running averages for columns. I am running Excel 2016 on Windows 10.

The answer choices for the column are "yes" "no" and I want a running average of the "yes" answers.



I found some tutorials on using COUNTIF/COUNTA. But, all the examples show using a defined data range and I this is an open-ended column, hence my need for a running average that would recalculate when a new cell is populated.

I hope this makes sense.

Is someone able to assist with a formula that I can use for this?

Much appreciated.