Minimum count greater than zero

alnav89

New Member
Joined
Sep 19, 2003
Messages
31
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
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
If column A, A1 thru A7 has grades, then:

=SUMIF(A1:A7,">"&0)/COUNTIF(A1:A7,">"&0)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,084
Messages
5,570,129
Members
412,305
Latest member
Mozz
Top