W
WOLLAM
Hopefully someone can help me with this. I am trying to
keep track of various sports when they play under certain
conditions, for example, when they play away or at home,
against a team in their conference or out of their
conference. Below is an example of what I hope the end
result will look similar to:
YEAR HOME AWAY
2000 2-6 4-4
2001 5-3 6-2
2002 5-3 1-7
total 12-12 11-13
In this instance, the HOME record for 2000, 2-6, would
appear in it's own cell. All of the other records would
also occupy their own cell, as well as the totals, 12-12
and 11-13.
My question is this, is there a way to place each of
these 'yearly won-loss records' into their own cell and
produce their cumulative records, totals, in another
cell?
keep track of various sports when they play under certain
conditions, for example, when they play away or at home,
against a team in their conference or out of their
conference. Below is an example of what I hope the end
result will look similar to:
YEAR HOME AWAY
2000 2-6 4-4
2001 5-3 6-2
2002 5-3 1-7
total 12-12 11-13
In this instance, the HOME record for 2000, 2-6, would
appear in it's own cell. All of the other records would
also occupy their own cell, as well as the totals, 12-12
and 11-13.
My question is this, is there a way to place each of
these 'yearly won-loss records' into their own cell and
produce their cumulative records, totals, in another
cell?