G Guest May 30, 2007 #1 I understand how to calculate the average ignoring zero values, but I need to ignore 0, 1, and 2 values.
I understand how to calculate the average ignoring zero values, but I need to ignore 0, 1, and 2 values.
G Guest May 30, 2007 #2 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 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 May 30, 2007 #3 I am assuming that you can't have negative values =SUMIF(A2:A100,">2")/COUNTIF(A2:A100,">2")
