Count cells that have a number 0
 

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

Count cells that have a number 0
 

use following function

=COUNTIF(A:A,"0")

"Fly Boy 5" wrote:

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

Count cells that have a number 0
 

One way:

1-60 minutes:

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

or, alternatively:

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

1-12 hours:

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

or, alternatively:

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


In article ,
Fly Boy 5 wrote:

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

Count cells that have a number 0
 

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


"sand" wrote:

use following function

=COUNTIF(A:A,"0")

"Fly Boy 5" wrote:

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