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.

[dmggilbert@gmail.com]

Oh crap, sorry. Here is the file unprotected.

[miguel-c]

To avoid DIV/0 you should use IF statements.
You can go to E10 and type: =IF(D10=0;"";SUM(C10/D10))
Then do the same to similar cells on column E
And filnally on E20 you should =IF(SUM(E10:E18)=0;"";AVERAGE(E10:E19))
See attached.

[dmggilbert@gmail.com]

Thank you miguel-c. I guess I have a lot to learn about formulas.