Is this a complicated countifs formula or something else?

I really have no idea how to do this, could anyone please help me? It's a bit challenging.

I have three columns like this:

Yes	No	No
No	Yes	No
Yes	Yes	No
No	No	Yes
No	No	No

I need a formula that can tell me how many rows have a Yes in them, but NOT to total all the Yes's. Something like "Is there a Yes in the first column? No. Okay, is there a Yes in the second column? Yes. Okay, next row".

Or, I was thinking maybe a formula for each row that returns a 1 for each row that has a Yes in it, and then add up all the 1s. The only problem with that is it creates another column, unless there is a way to make a column invisible?

So the automatically calculated result for this table should be 4.

Thanks for the help, I'm fairly new with excel.

Hi eefen,

Suggest you to please change the title of your thread to describe the query being asked ... see the forum rules :-

http://www.excelforum.com/forum-rule...rum-rules.html

Regards,
DILIPandey

<click on below 'star' if this helps>

Thanks eefen ...

You can use the formula :-

=IF(COUNTIF(A1:C1,"Yes")>=1,1,0)

Counting yes.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

Yes.. You can hide that extra formula column and good to go...
Make sure you move the sum formula to other column if you want to see that ...

Regards,
DILIPandey

<click on below 'star' if this helps>