Calculate the average of numbers, ignoring multiple values

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

Guest

I understand how to calculate the average ignoring zero values, but I need to
ignore 0, 1, and 2 values.
 
I don't understand what you mean
do you want to ignore integers?
do you want to ignore multiples?
how do you identify what you want to ignore?
 
I am assuming that you can't have negative values

=SUMIF(A2:A100,">2")/COUNTIF(A2:A100,">2")
 

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

average of different cells ignoring zero values 1
Help! Need to ignore 0s and blank cells in average formula! 2
MAX AVERAGE MIN with additional criteria, ignoring blank cells 6
Calculation of average improvement? 0
ignore MAX and MIN values in a set to calculate average 5
Array average question 6
Median calculation and ignore zeros 5
skip 0 average 4

Back
Top