You can create your own average

=SUMIF(4:4,"0")/COUNTIF(4:4,"0")

"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