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).
 
How about:
=SUM(A2:L2)/(COUNTIF(A2:L2,"<>" & 0)-COUNTBLANK(A2: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"))
 
You must log in or register to reply here.

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
Averaging non consecutive cells excluding zero's 4
Selection multiple ranges with Cells property 4
Calculating average of percentages 7
average in non-continuous set, excluding blanks 6
Selecting non adjacent cell ranges 6

Back
Top