When using Quattro Pro, I can use a function "PureAverage" to average a series, even if some cells of the series contain unsatisfied formulas. "PureAverage" ignors these cells and averages the remaining cell values. Does Excel have a similar function??
Steve Wagner
Stiffler, McGraw & Assoc.
Hollidaysburg PA
Steve Wagner
Stiffler, McGraw & Assoc.
Hollidaysburg PA