I'd have a line for each game, with team names in columns A and D, and the
scores in column B and C. Then I'd have a results in columns E and F (which
can eventually be hidden), with the following formulas.

Column E, for the result of the team in column A:
=IF(OR(ISBLANK(B2),ISBLANK(C2)),"",IF(B2C2,"W",IF (C2B2,"L","T")))

Column F, for the result of the team in column B:
=IF(OR(ISBLANK(B2),ISBLANK(C2)),"",IF(C2B2,"W",IF (B2C2,"L","T")))
or more simply:
=IF(E2="W","L",if(E2="L","W",E2))

Then a table (in a new worksheet) to tally the results:
Cell A2 has team name
Cell B2 has wins:
=Sum(if(Sheet1!A1:A200=A2,if(Sheet1!E1:E200="W",1, 0)))+Sum(if(Sheet1!D1:D200=A2,if(Sheet1!F1:F200="W ",1,0)))
Cell C2 has losses:
=Sum(if(Sheet1!A1:A200=A2,if(Sheet1!E1:E200="L",1, 0)))+Sum(if(Sheet1!D1:D200=A2,if(Sheet1!F1:F200="L ",1,0)))

Note that these last two are array formulas, so press Control-Shift-Enter.
And adjust the 200 if there are more games to count. Or instead of doing
array formulas, you could have the formula in the results columns of Sheet1
return something like "BullsWin" or "BullsLose" in place of "W" and "L", then
count wins and losses this way:
=COUNTIF(Sheet1!E1:F200,A2&"Win")
=COUNTIF(Sheet1!E1:F200,A2&"Lose")

"rayammo461" wrote:

I have created a scoring spreadsheet for a fantasy basketball league. I'm
trying to automatically calculate the wins and losses rather than calculate
them manually. How do I do this??

send responses to: