Calculate the average of numbers, ignoring multiple values

Q

Quintessence

I understand how to calculate the average ignoring zero values, but I need to
ignore 0, 1, and 2 values.
 
B

bj

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?
 
P

Peo Sjoblom

I am assuming that you can't have negative values

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