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.



By: Lynn

Leave a Reply

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