How to COUNTIF with duration (h:mm:mm) where cell with value = 1

[Ebbie]

Hello,

I have a sheet with duration values. I already can count the total amount of a specific area (ex : B2:G2) to get the total of time, that's easy and not an issue.
However, I would want to get à value = 1 for each cell in the area where there's a duration. So if I have :

1:00:00
[blank cell]
0:30:00
0:10:30
[blank cell]
2:30:00
[blank cell]
[blank cell]
0:27:34

I would get the result 5 for each time there isn't a blank cell.

The issue I face is that when I use COUNTIF (value1:value2;"*") or COUNTIF (value1:value2;"?"), it doesn't count anything at all. I'm at a lost because it's hard for me to think of another way to do what I want to do AND I don't know how to correctly formulate my question with good keyword for Google to be helpful in that instance.

Please help!

Thank you!

 

[etaf]

have you tried counta()
which counts only cells with content and NOT blanks

Book2.xlsx
	A	B	C	D
1	1:00:00		5
2
3	0:30:00
4	0:10:30
5
6	2:30:00
7
8
9	0:27:34
10
Sheet3

Cell Formulas
Range	Formula
C1	C1	=COUNTA(A1:A13)

 

[Ebbie]

have you tried counta()
which counts only cells with content and NOT blanks

Book2.xlsx
	A	B	C	D
1	1:00:00		5
2
3	0:30:00
4	0:10:30
5
6	2:30:00
7
8
9	0:27:34
10
Sheet3

Cell Formulas
Range	Formula
C1	C1	=COUNTA(A1:A13)

I have not. Just did and it worked!!!
Thank you so much for the help, so easy yet couldn't find it ahah

 

[etaf]

you are welcome