Count cells that have a number >0

[Guest]

00:00 Don't count
00:01 Count
00:10 Count
01:00 Count
12:01 Count

I want to count a column that has 1 to 60 minutes and 1 to 12 hrs.

Any help would be appreciated.

Fly Boy 5

 

[Guest]

use following function

=COUNTIF(A:A,">0")

 

[JE McGimpsey]

One way:

1-60 minutes:

=COUNTIF(A:A,">0") - COUNTIF(A:A,">" & 1/24)

or, alternatively:

=SUMPRODUCT(--(A1:A100>0),--(A1:A100<=1/24))

1-12 hours:

=COUNTIF(A:A,">" & 1/24) - COUNTIF(A:A,">" & 12/24)

or, alternatively:

=SUMPRODUCT(--(A1:A100>1/24),--(A1:A100<=0.5))

 

[Guest]

Thanks, it worked great!!!!!!!!!!!!

use following function

=COUNTIF(A:A,">0")