Hello! from what I know, Average ignores blank cells, so you just have to go run the average function and the values you want to average, and you should be okay.

I learned many things about the average function in excel he
https://www.efinancialmodels.com/kno...rage-function/

Hope this helps!