I'm assuming you want to ignore 0 values?

In that case, =SUM(A1:A10)/COUNTIF(A1:A10,"0")

This divides the sum of A1:A10 by the count of values in A1:A10 which are
greater than zero.

Dave
--
Brevity is the soul of wit.


"Todd" wrote:

How do you average a column that contains formulas, when some of the formula
results are zero?
--
Todd