Excel Tracking Win Loss

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Have a table with two columns for: "Points For" and "Points Against". I want
to have in a different table on the same worksheet to calculate their record
when I enter the points over the eight games. Wondering what formula I need
to enter in where "wins" and ""Losses" are to be displayed
 
Wins =SUM(--(A2:A9>B2:B9))
Losses =SUM(--(B2:B9>A2:A9))
In each case the formula needs to be entered as an array formula: Control
Shift Enter
 
Thank you very much

David Biddulph said:
Wins =SUM(--(A2:A9>B2:B9))
Losses =SUM(--(B2:B9>A2:A9))
In each case the formula needs to be entered as an array formula: Control
Shift Enter
Click to expand...
 
Back
Top