Nesting an OR Function within an AverageIF.

[LuxuryWatch]

I want to calculate the average 'ELO Change', provided that
i) The ELO Change was >0
ii) A given hero appeared in that row (e.g., D.Va)

I've managed to do it if only 1 hero appears per row, and my formula for that was:
=AVERAGEIFS(Table1[ELO Change],Table1[Hero 1], Q14, Table1[Hero 2], "", Table1[Hero 3],"",Table1[ELO Change], ">0")
In words, if the Hero @Q14 appeared in col Hero 1, the positive ELO change would be averaged.

Where Q14 was the Hero in question.
I can't seem to do:
=AVERAGEIFS(Table1[ELO Change], Table1[Hero 1]:Table1[Hero 2]:Table1[Hero 3],Q6, Table1[ELO Change], ">0")
as it returns #VALUE !

I'm trying to nest an OR function in there, but unsure how to go about it.

Any help would be greatly appreciated.

 

[LuxuryWatch]

Here's an image of the table to help clarify.