hallo

i use a excel sheet to count the points gaint in an competition with model sail boats

i have this problem i kant solve


example of a row with the points


day1 day2 day3 day4 day5 total classement
4 2 6 4 0 10 2
0 0 1 1 0 2 1


the total collum counts the points and then takes the highest score from the total
the lower your points the better you are
the first to arrive gets one point the second two points the therd three points etc..

in row two the guy was won two of the 5 events there and normaly he has won but due to the three times he was not there he is not classyfiet

how doe i count the two or three zero's in the row and put in the classemet collum NC


greatings raf