Count IF with mutiple OR statements

 

I’m trying to write a formula in excel to count the number of rows with “Yes” in column J only if column I has the entries “BJJ” or “KB”.

This is what I have tried so far:

Countif(or(I1:I100,”BJJ”,I1:I100,”KB”)),J1:j100=”yes”

By: Ed Gentry

Leave a Reply

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