Average Percentages Excluding Zero Percentages
 

I was curious to find out how you can find the average percent of a
group of percentages that will exclude percentages of zero.

The example of the incorrect formula is:

=IF(COUNT(H108,I84,I60,I35,I11)0,AVERAGE(H108,I84 ,I60,I35,I11),
"0.00%")

**where all the cell numbers are filled with either a percentage
ranging from 0% to 100%

Thanks again,
MPH