How do I exclude zero's from an average of five non-adjacent cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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).
 
this may work, you didn't specilfy if there were or weren't any other
numbers in the row that you didn't want in the average.

=SUMIF(A2:N2,">0")/MAX(1,COUNTIF(A2:N2,">0"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I exclude a cell from a range? 4
Average non-adjacent cells & exclude zeros 3
copy non adjacent cells 0
Selection multiple ranges with Cells property 4
Averaging non consecutive cells excluding zero's 4
Another Average non-adjacent cells question... 2
average in non-continuous set, excluding blanks 6
Average excluding zero-value cells 4

Back
Top