Hi, I am trying to work out how to sum a number from a cell that contains multiple bits of information. My information is like this
Game 1 Player A - 2, Player B - 1, Player C - 1
Game 2 Player A - 2, Player C - 2
Game 3 Player B - 2

I want to be able to sum the number after - for each player so that a get a total for a particular player i.e. Player A - Sum = 4.

Is this possible in excel? Appreciate any help anyone can give!