• 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.

Searching cells for yes

Deepak, on the second formula =N(COUNTIF(C4:C10,"Yes")>0), I need to search cells that are not in sequence (C4,C6,C7,C8,C10). When I erase C4:C10 in your formula and click on the individual cells I need searched for yes (C4,C6, C7,C8,C10), I get an error message stating, "You've entered too many arguments for this function". How do I change the formula to search for certain non-sequential cells? Thanks.
 
Sorry!

I doesn't check the 2nd part.

=N(SUM(COUNTIF(INDIRECT({"C21:C22","C24:C25"}),"Yes"))>0)

The drawback for the above formula is that u can't simply drag it, Need to change the range manually.

Else, Something like.

=N((COUNTIF(C21:C22,"Yes")+COUNTIF(C24:C25,"Yes")+(C27="Yes"))>0)
 
Another option for 2nd part.

In C19, copy across

=0+(SUM(COUNTIF(OFFSET(C21,{0,3},,2),"Yes"))>0)

And,

If you wanted to search for "Yes" in C4,C6,C7,C8,C10 (as per post #3)

try :

=0+(SUM(COUNTIF(OFFSET(C4,{0,2,3,4,6},),"Yes"))>0)

Formula copy across

Regards
Bosco
 
Last edited:
Back
Top