Count cells with positive numbers

J

Jamie

In a row of 20 cells from A1:T1, how can I count the number of cells that
are greater than 0?
Thanks for your help.

Jamie
 
J

Jamie

My thanks to Gary"s Student and L. Howard Kittle.
One question though, by putting the quotation marks around >0, doesn't
that change it into a text? I thought Excel can understand numeric argument.
 
L

L. Howard Kittle

Hi Jamie,

COUNTIF is a bit bountiful with the " "'s and without. I keep a list of
about 20 different formula's of COUNTIF to keep me straight.

Some examples using Data, a named range, as the Range.

=Countif(Data,12) the number of cells containing the value 12
=Countif(Data,A1) the number of cells equal to the contents of A1.
=Countif(Data,TODAY()) the number of cells containing current date
=Countif(Data,TRUE) the number of cells containing logical true.
=Countif(Data,"*") the number of cells containing text.
=Countif(Data,"???") the number of cells containing exactly 3 characters.

HTH
Regards,
Howard
 
J

Jamie

Thanks again. Those are worth knowing.

L. Howard Kittle said:
Hi Jamie,

COUNTIF is a bit bountiful with the " "'s and without. I keep a list of
about 20 different formula's of COUNTIF to keep me straight.

Some examples using Data, a named range, as the Range.

=Countif(Data,12) the number of cells containing the value 12
=Countif(Data,A1) the number of cells equal to the contents of A1.
=Countif(Data,TODAY()) the number of cells containing current date
=Countif(Data,TRUE) the number of cells containing logical true.
=Countif(Data,"*") the number of cells containing text.
=Countif(Data,"???") the number of cells containing exactly 3 characters.

HTH
Regards,
Howard
Click to expand...
 
Top