countifs arrays

[zimzim]

Hello, I'm trying to evaluate two ranges within a countifs formula for any potential identical values.

I have a calendar/schedule sheet with the days of the week and two rows of values using a three character letter code (ABC for the sake of the formula below) and a four digit number code indicating schedule.

I am using this formula:
=countifs(a3:a33,"SU",c3:c33,"ABC",b3:b33,????)
Where a3:a33 is a list of days of the week
c3:c33 is a list of three letter codes corresponding to certain schedules (ABC, etc.)
and b3:b33 is a list of four digit codes on the schedule
???? indicates the list of acceptable codes I'm trying to compare to b3:b33

I have gone through the four digit codes and determined that 12 of several hundred possibilities are the ones I'm specifically seeking and I have those saved in aa3:aa14.

How do I determine whether the corresponding value in b3:b33 matches any of the values in aa3:aa14? I have tried several variations and found no success. I've even looked into CSE formulas for evaluate multiple arrays. What am I missing here?

If countifs isn't the best function, is there a better function for this? Thanks!

 

[konew1]

You have days of the week in A3:A33.
Are these dates that are formatted to show alpha for the day (like "SU" in your example) or are they text "SU".
Your formula will not fine a date formatted to show "SU"