How to count the number of cells used, but ignor 0
 

I need to find the percent of a column for the number of students that turned
in reading logs. I used the =count function and divided it by the number of
total students to get the percent. The problem is if they did not turn in a
reading log, I need to record it as 0 and the =count function will count it.
Is there a way to make it only count 0<1?

Thanks

How to count the number of cells used, but ignor 0
 

The countif function allows you to count the number of cells meeting one
condition. In this case =countif(b2:b10,"0"). --Bruce

"rmwarde" wrote:

I need to find the percent of a column for the number of students that turned
in reading logs. I used the =count function and divided it by the number of
total students to get the percent. The problem is if they did not turn in a
reading log, I need to record it as 0 and the =count function will count it.
Is there a way to make it only count 0<1?

Thanks

How to count the number of cells used, but ignor 0
 

Perfect thanks...


"bpeltzer" wrote:

The countif function allows you to count the number of cells meeting one
condition. In this case =countif(b2:b10,"0"). --Bruce

"rmwarde" wrote:

I need to find the percent of a column for the number of students that turned
in reading logs. I used the =count function and divided it by the number of
total students to get the percent. The problem is if they did not turn in a
reading log, I need to record it as 0 and the =count function will count it.
Is there a way to make it only count 0<1?

Thanks