Thread: sum cell based on criteria countif formula assistance

You might have to explain the exact logic you want using the latest example... but this is what I did.

In K6:

=LOOKUP(REPT("z",99),J$6:J6)

copied down... so each row has a team reference.

In D10:

=MAX(0,COUNTIFS($K$6:$K$49,$C10,H$6:H$49,D$8)-COUNTIFS($K$6:$K$49,$C10,I$6:I$49,E$8))

copied down. Counts the total wins for each team and subtracts losses (if negative, then 0)

in D11:

=MAX(0,COUNTIFS($K$6:$K$49,$C10,I$6:I$49,E$8)-COUNTIFS($K$6:$K$49,$C10,H$6:H$49,D$8))

copied down. Counts the total losses for each team and subtracts wins (if negative, then 0)

Im unsure how i can clarify it any differently.
I figured most people can understand wins and losses.

Is there maybe a question you have that I can answer better to help you..
other than that, im having trouble thinking of a way to explain.

I did fix "wins" to "win" since you were pulling from D8 and fixed it from not seeing the correct text.

all i need at this point is to say..If team1 is in column J6:J48 Compare if wins are > or < Loss by player. If wins>Loss for Team1, then Team1 in D10:E10 should say 1-0..(1win 1loss) because out of the 5 games played, Players wins oversee losses as a whole...that goes for all teams 1,2,3,4,5,6,etc

When Team1 is played again at a later date (lets say in J28) and loss>win then D10:E10 should say 1-1 ..which states, that after 2 games, My team won the first meeting against team1 and lost the second meeting.

I placed the correct numbers Im looking for in D10:E13 on my example so you can see in newest example.

Thanks again.