Creating a win/loss record in numbers?

Question

Level 1

8 points

Creating a win/loss record in numbers?

I have begun keeping track of my current scores in my small "wiffle ball" league, made up of just two teams.

Assuming it is possible, I would like to create a spread sheet not only keeping track of scores, but win/loss record as well.

Here was the spread sheet looks like thus far.

As you can see, there are two teams, team one being "DCBI," and the other being "Obama." DCBI has 2 wins, while Obama has 0.

For some reason the grids marking the column do not show in this picture, but the quadrant labled "Home Team" is A1, while "Total Obama Wins" is K1"

I know I could make a column labeled "obama win" and "dcbi win" and make a =total(K2:K21) and =total(J2:J21) sort of thing, and do the same for losses, but I know there has to be some way of having Numbers do the work for me, by analyzing the final score of each game (higher score being the winner, lower score being the person recieving the loss) and end up with a column somewhere along the lines of "DCBI Win/Loss" and "Obama Win/Loss" I've experimented with a few "=countif" s but I am pretty foggy on how they work. Any help would be great!

Thanks!

Davis

OS X Mavericks (10.9.2)

Posted on Jun 4, 2014 4:15 PM

Reply

Answer 1

Jun 4, 2014 6:30 PM in response to Davis Deaton

For some reason the grids marking the column do not show in this picture,

if you have the table selected (you clicked any cell(s)) the row/column headers will show

You can use some extra columns (which you can hide) to assist in making the calculation:

I added new columns (D and F).

D2=C2>E2

this is shorthand for select cell D2, then type (or copy from here) the formula:

=C2>E2

select cell D2, copy

select column D by clicking the column header (the "D" at the very top)

unselect cell D1 by holding the command key while single clicking cell D1

paste

F2=E2>C2

fill down like before

C10 is the win total for DCBI in this example AND is a footer row:

C10=COUNTIF(D, TRUE)

F10=COUNTIF(F, TRUE)

Reply

Answer 2

Davis Deaton Author

Level 1

8 points

Jun 4, 2014 9:23 PM in response to Wayne Contello

Could not have been easier, quicker, organized, or come from a more helpful person! Thank you so much for taking the time to help me, it really means a lot!

Reply