Using IF function for multiple outcomes

Hey Guys -

I am in the process of setting up a fantasy football league; however this is a bit different than standard leagues.

Essentially each team (12) plays the (11) other teams each week. I am trying to create a function where I can input each team's points for the week and get a total number "wins" and "losses" for each week.

I am able to do for example =IF(D7>E7,1) which brings the cell to 1 win if D7 is greater than E7. Is there a quicker way to do this?

Wins: =COUNTIF(E7:E17,"<"&D7)
Losses: =COUNTIF(E7:E17,">"&D7)
Ties: =COUNTIF(E7:E17,D7)

See attached.

Thanks Eibi.

That worked wonders.

I attached my file for your review. The function works properly for =COUNTIF(D21:D31,"<"&D20) However, when I want to do the next "team" it won't work. =COUNTIF(D33,D35:D44,"<"&D34)

Help again?

In cell M22?

You need: =COUNTIF(D33:D44,"<"&D34)

Similarly, in cell M23, for example, you need:

=COUNTIF(D46:D57,"<"&D48)

Is this what you're looking for?

In the sample formula you provided: =COUNTIF(D33,D35:D44,"<"&D34) it looks like you are trying to exclude D34 from the Countif() range, but no need to exclude it because it will never get counted by your win or loss formula.