Hello everyone,

I have a set of percents (cells B30 - I30) that I would like to
average, but I want to eliminate any percents that equal zero. Using
the average function, it takes into account zeros, thus skewing my
average. Is there a function that I can use that will eliminate zeros
from my average and give a true percent average?