A alnav89 New Member Joined Sep 19, 2003 Messages 31 Dec 2, 2005 #1 I have a column of grades, I want to get the minimum grade that is greater than zero (in other words I do not want it to count zero as a minimum grade)... is there a formula that I can use? thanx in advance
I have a column of grades, I want to get the minimum grade that is greater than zero (in other words I do not want it to count zero as a minimum grade)... is there a formula that I can use? thanx in advance
N nbrcrunch Well-known Member Joined Jan 1, 2003 Messages 2,062 Dec 2, 2005 #2 If column A, A1 thru A7 has grades, then: =SUMIF(A1:A7,">"&0)/COUNTIF(A1:A7,">"&0)