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

[rmwarde]

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

[bpeltzer]

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

[rmwarde]

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