Averaging percentages

Post Reply
dmggilbert@gmail.com
Posts: 3
Joined: Sun Jun 28, 2020 4:03 am

Averaging percentages

Post by dmggilbert@gmail.com » Mon Jan 11, 2021 5:08 pm

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.
Attachments
Tucson Flag Sheet.xlsx
(60.5 KiB) Downloaded 1 time

SuperTech
SoftMaker Team
SoftMaker Team
Posts: 1151
Joined: Wed Mar 11, 2020 5:31 pm

Re: Averaging percentages

Post by SuperTech » Tue Jan 19, 2021 4:51 am

The file you shared is password protected.

Post Reply

Return to “PlanMaker 2021 for Windows”