Average Percentages Excluding Zero Percentages

M

MPHernandez

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top