Countif with Multiple Criteria and Or Scenarios

I am trying to get a formula:

 

I have 3 columns (A, B, C)

I want the formula to count if (cells A2 and C2 = yes) OR if (cells B2 and C2 = yes)

How would I do that? I have tried to figure it out on my own and just can’t seem to get it.

 

Thanks!!!!! 

By: Lynn

Leave a Reply

Your email address will not be published. Required fields are marked *