COUNT OR COUNTIF for this?

[Zakynthos]

I have up to 7 time-formatted data in between c3-p3.

I want to count all valuies except those showing as "00:00", then divide the
result by 2.

Should I do this with COUNT or COUNTIF and if so, what would be the form of
the expression?

Many thanks for your help.

 

[Gunti]

I guess =COUNTIF(C33;"<>0:00") should do the trick.

Greets,
Gunti

 

[Gunti]

Dividing this by 2 is obviously =((Countif(C33;"<>0:00")/2)

 

[Zakynthos]

Gunti,

Much appreciated - worked perfectly!

Dividing this by 2 is obviously =((Countif(C33;"<>0:00")/2)