Please help with unreliable bettor score formula

[juntjoo]

Bettor score

This is a sheet supposed to keep score of bettor's picks on underdogs in fights. So picks on favorites shouldn't count. When I first write it out from scratch it works right but after a while for some reasons starts not working erratically.

"underdogs" are determined where the odds value is higher for one fighter than the other...

the winner is determined where "1" is in the fighter name....

and winning picks are determined where the bettor picks the winner who's odds are greater(underdog) than the other fighter and the losing picks are determined where bettor picks underdog who doesn't win.

Any ideas why these formulas will work at first then stop working right?

I also have this thread here: Please help with unreliable bettor score formula

 

[BigBeachBananas]

Your question is unclear. Is it possible to provide sample input and desired outcome?

 

[juntjoo]

Your question is unclear. Is it possible to provide sample input and desired outcome?

Sample sheet

This should produce 2 "unsuccessful underdog bets" and 1 successful one. You can see who the underdogs are by their higher odds than their opponents. "unsuccessful" would be where the underdog loses, where there's a "1" next to the fighter's name who won. Thanks!