View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default Finding the Average

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