COUNT OR COUNTIF for this?
 

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.

COUNT OR COUNTIF for this?
 

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

Greets,
Gunti

"Zakynthos" wrote:

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.

COUNT OR COUNTIF for this?
 

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

"Gunti" wrote:

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

Greets,
Gunti

"Zakynthos" wrote:

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.

COUNT OR COUNTIF for this?
 

Gunti,

Much appreciated - worked perfectly!

"Gunti" wrote:

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

"Gunti" wrote:

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

Greets,
Gunti

"Zakynthos" wrote:

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.