• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

I have a countif question

Ellasheba

New Member
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
 

Peter Bartholomew

Well-Known Member
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
 
Top