I have a countif question

[Ellasheba]

Hi I have one horizontal countif ... =COUNTIF(D6:Z6,"*") bringing back a count and I want to capture the resulting cell return that is greater than 0 in a vertical countif - I have used =COUNTIF(C6:C96,">0") but it keeps coming back with 0.
This does not seem to want to work on Excel 2016 desktop app

 

[Suresh Raju]

try this format COUNTIFS(C2:C1500,">=0:01:01",C2:C1500,"<=0:05:00")

 

[Ellasheba]

try this format COUNTIFS(C2:C1500,">=0:01:01",C2:C1500,"<=0:05:00")

thanks i will try this and report back

 

[pecoflyer]

Perhaps post a sample sheet with some data and expected results?

 

[Peter Bartholomew]

I see no reason why your formula should have failed. Perhaps an alternative might be
= SUM(SIGN(matches))
where 'matches' is refers to
=C6:C96

 

[Ellasheba]

thanks i will try this and report back

thanks i will try this and report back

Didn

I see no reason why your formula should have failed. Perhaps an alternative might be
= SUM(SIGN(matches))
where 'matches' is refers to
=C6:C96

I know! Funny thing is now I put an additional row into the worksheet it is working as I set it up - thank you !