Formula miscounting issue

[Brown]

Good morning,
I am trying to calculate the wins and losses in this spreadsheet. Thanks to some very helpful people on this forum I was able to get the wins to calculate correctly. I was trying to figure out how to calculate the losses, and it is not working quite right. Can someone assist me with this formula?
As you can see in the screen shot, my formula for I 3 is showing losses but the team has only played one game. Where is my formula coming up short?
Thanks for your time and thoughts.
Have a nice day
Brown

 

[dmheller]

i dont know what you have in H3 but I3 will always equal 2 in that case. I am assuming in H3 you count winner column. So do that then for losses you can count number of times they appear in B or D then subtract the 2. That way brookwood who played one time and won one time would have 0 losses your equation -(sum(countif(B3:B9,{"teams"})+sum(countif(D3:D9,{"teams"})

 

[Joe4]

If I am understanding this correctly, I think you making it harder than it has to be.

Formula for H3 (and then copy down):

=COUNTIF($F$3:$F$9,$G3)

Formula for I3 (and then copy down):

=COUNTIF($B$3:$D$9,$G3)-H3

 

[Brown]

Thank you both. I am sure I was making it harder than it had to be. I just wasnt wrapping my head around it correctly.
Have a great day and thank you so much for the clarification.
Brown

 

[Joe4]

You are welcome.
Glad that we could help!

 

[Brown]

why does it show there is a loss and there is no score? As soon as I build the game schedule each team gets losses.

 

[Joe4]

You hadn't presented that possibility before.
If you look at what the formula is doing, it is counting how many times that value appears in columns B and D, as that indicates that they are playing a game.
And then it subtracts the number of times that value appears in the Win column.

Why would you have a lone value in column B or D, like you show above?
Why would they appear in there if they are not playing a game?
It doesn't really seem to make sense, they way you have this structured.

 

[Brown]

You hadn't presented that possibility before.
If you look at what the formula is doing, it is counting how many times that value appears in columns B and D, as that indicates that they are playing a game.
And then it subtracts the number of times that value appears in the Win column.

Why would you have a lone value in column B or D, like you show above?
Why would they appear in there if they are not playing a game?
It doesn't really seem to make sense, they way you have this structured.

That makes sense. So this is the schedule they will play this weekend, and I will have a score keeper simply place the scores in the box at the end of the game. This also helps people know who will be playing at what time on what field.
Is there a simple way to make it show zero losses before we enter a score similar to the zero wins prior to playing?
Thanks
Brown

 

[Joe4]

Is there a simple way to make it show zero losses before we enter a score similar to the zero wins prior to playing?

My formulas should already do that, if you are using them as I have written them.
If you are not seeing a zero, check column I for Custom Formatting or Conditional Formatting that might be hiding those zeroes.