View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MikeG MikeG is offline
external usenet poster
 
Posts: 18
Default How do I exclude zero's from an average of five non-adjacent cells

I am trying to average the values in several non-adjacent cells in a row, and
a number of them contain zero values. How do I exclude the zero values from
the average? They are non-adjacent, or not in a specific range (e.g., they
may be in cells A2, C2, F2, J2, L2).