AverageIF for group of people in longer list

Hello,

I've been searching forums everywhere, and have tried many things, but can not figure out how to do this.

I have a long list of employee titles, and scores for each of them. I would like to take the average of only a select group of those employees. There are multiple data points with the same title. For example, if there were fifteen titles, I would like to know the average for just a group of three of those titles.

=AVERAGE(IF((ALL TITLES=A1:A3)*(ALL TITLES=Title One)*(ALL TITLES=Title One)*(Score>0),Score))
...where A1:A3 are the select titles I would like to average for.

More explicitly, I tried:

=AVERAGE(IF((ALL TITLES=Title One)*(ALL TITLES=Title Two)*(ALL TITLES=Title Three)*(Score>0),Score))

...I know Arrays are usually for saying condition one AND condition two, but I am trying to say Condition one or Condition two (Without the OR function because that relies on true/false.

I've been able to successfully use this formula for finding the average for a single title, but the challenge has been saying "if any of these titles match any titles in the list, then take the average of just those". I have tried AverageIFS, Sumif/Countif, Vloookup to no avail. I am doing this for 66 different categories, which is why I am trying to consolidate this into one formula.

Try

=AVERAGE(IF( ( (ALL TITLES=Title One) + (ALL TITLES=Title Two) + (ALL TITLES=Title Three) ) * (Score>0), Score))

The first three terms are mutually exclusive, so their sum can be, at most, 1.