Nielz....when the divisor consider the count of negative number, then the
zero must be included in the count for the divisor....what do you think?

"Nielz" wrote:

Todd,

You could try sum / sumproduct. Ex. =SUM(A1:E1)/(SUMPRODUCT((A1:E1<0)*1))

"Todd" skrev i en meddelelse
...
How do you average a column that contains formulas, when some of the
formula
results are zero?
--
Todd