Left, Right with count.

I am looking to add a count function in a formula to compute the win % of sports teams. Ihe formula I have works but I need to adjust the count manually.

Currently if a team has less than 10 wins or 10 losses I can use 'Left or right with 1' but when a team goes into a double digit number I need to change the count to 2. I think some sort of count or countif would be the solution but I am not sure how to add that function into my formula (see attached).


Jim O

You could try something like

=IFERROR(LEFT(E2,FIND("-",E2)-1)/SUM(LEFT(E2,FIND("-",E2)-1)+RIGHT(E2,LEN(E2)-FIND("-",E2))),0)

does the team record always take the format
85-77
6-9

with a dash

you could use the - to find what to extract

for the left number

=LEFT(E2,FIND("-",E2,1)-1)

for right number
=MID(E2,FIND("-",E2,1)+1,3)

so
=IFERROR(LEFT(E2,FIND("-",E2,1)-1)/(LEFT(E2,FIND("-",E2,1)-1)+MID(E2,FIND("-",E2,1)+1,3)),0)