Formula to count occurrences, multiple ranges, multiple criteria, with wildcard

Hello Experts,

I am trying to figure out an Excel formula that will accomplish the following. I am trying to count occurrences based on 2 columns/ranges worth of data and 3 criteria. I'll write it out as a mathematical expression:

(Range1 = "Y)" AND ((Range2 = "Phase4") OR (Range2 = "Transitioned on*"))

So, I am trying to count the number of instances where elements in Range 1 = "Y" and elements in Range2 = "Phase4" OR "Transitioned on*". Please note the wildcard.

Any help coming up with this formula would be appreciated. Thank you.

TMc

Try

=SUM(COUNTIFS(Range1,"Y",Range2,{"Phase4","Transitioned on"})

Perfect! Thant's exactly what I needed. Thanks for your help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.