Averaging percentages

[dmggilbert@gmail.com]

Sorry if this sounds like a stupid question to most of you but I have searched the internet and have not been able to find the solution to my question not to mention I am new to creating formulas and trying to learn.

I have a column of percentages and each row (a different day) are calculated daily. I want to be able to average the percentages of all the days as they are entered. As of now I have an "average" equation set at the bottom of each column but because the next day does not have a value entered yet the cell with the average equation shows "#DIV/0!". I want the equation to recognize only cells that have a numerical value entered.

I also want to add a bonus based off of these percentages which change based on the percentage. See the bonus section of the workbook for details.

I have attached the file I am working on for anyone interested in offering me some assistance. See Sheet "2021 Daily Flag" of the workbook for all the relevant information I am referring to.

Thank you in advance for your assistance.

[SuperTech]

The file you shared is password protected.