How can I get a correct average of several percentages that include 0%?
I have 5 different percentages and they are 0%, 0%, 0%, 0%, and 100%. I do not want the average to be 100% since there are four 0%. Is there a way to have the formula include the 0s and give me some kind of percentage like 20%?
Answers
-
How are you currently getting the average? Are you able to provide screenshots for context?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!