i need a little help cause i couldnt find a way of doing what i want to. I will just describe what i wanna do instead of asking a direct question, cause i am not sure how to do this at all.

here is what the data i got looks like:



now if i wanna get the average score i just do =Average(...)
and if i wanna count how often clan X played a map i can just do =COUNTIF(...;"X")

but what i also want to do is take the average score for clan X. Is there a way to do this at all? how?