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).
|