Count cells with positive numbers

  • Thread starter Thread starter Jamie
  • Start date Start date
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
 
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.
 
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
 
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...
 
Back
Top