https://docs.google.com/spreadsheets...it?usp=sharing

How do I get the win %?

Originally I was trying =CountIf(A:A="BfG") / ... then I get stuck
I can't do CountIf(E:E="Alliance") because some of those are attached to a different battleground. How do?