help with ongoing bettor score please

Occasional Contributor

I hope I made it as self-explanatory as possible. I put notes in there. The end calculations I'm looking for help with are the total score in the top pink and green cells over the a bettor's ongoing game/fight score column.


There's a couple factors involved, the victor of the fight and the bettor's pick. Much thanks in advance as this to me looks really complicated, if anyone has the time to try this out for me.

sample sheet 

0 Replies