How can I get a correct average of several percentages that include 0%?

Michaela Collins

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

Paul Newcome

How are you currently getting the average? Are you able to provide screenshots for context?