hi
=SUM(A1:F1)/COUNTIF(A1:F1,"0")

Adjust to fit your data.

Regards
FSt1

"Mike H." wrote:

I want to average an entire row, but there are cells with the value of zero.
I only want to average the cells that have a value greater than zero. The
problem is this. I don't want to clear out the cells with the value of zero
because they are programmed with formulas. I need the average to continue to
modify when these cells value are greater than zero.
--
Mike H.
Data Review Specialist