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%?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!