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