Awesome Bill
New member
I want to design a worksheet that has a table within it which lists each team and their corresponding win-loss-tie data arranged very much like you will find in any newspaper or website.
The way that I've been doing it is to label three columns as "W" - "L" - "T" and insert a value of 1 into each column where it was applicable - across from each team. Say if my team won that particular game, (road teams are always in the left column) I would enter a 1 under the W and I have it designed so that a 1 automatically appears under the L in the opponents corresponding column. The result would look like this:
header > W - L - T - PF - PA header > W - L - T - PF - PA
My Team 1 - 0 - 0 - 20 - 17 Opponent 0 - 1 - 0 - 17 - 20
My goal is to do away with having to account for each outcome with the number 1 and instead use what I've been able to accomplish so far, which looks like this:
My team W 20 17 L Opponent
I've managed to accomplish that by entering the score manually and using this function:
=IF(F4>H4,"W",IF(F4<H4,"L",IF(F4=H4,"T")))
to decide if a W, L or T is to appear. The example used here is from the road team cell.
But that is where I'm stuck, ergo the question; how do I tabulate the outcomes for each team in another table where the wins are kept up to date and the same for losses and ties - each in a separate cell. I only recently began using SUMIF and COUNTIF functions, and this is the best I've managed so far (which results in #VALUE!):
=SUMIF(J2:J346,"My team",IF(I2:I346,"W","1"))
Your help will be greatly appreciated.
Hey, thanks for the suggestion. Too busy at the moment to try it. Just got home and a lot of gift wrap needs to get around some presents. Happy holidays.
The way that I've been doing it is to label three columns as "W" - "L" - "T" and insert a value of 1 into each column where it was applicable - across from each team. Say if my team won that particular game, (road teams are always in the left column) I would enter a 1 under the W and I have it designed so that a 1 automatically appears under the L in the opponents corresponding column. The result would look like this:
header > W - L - T - PF - PA header > W - L - T - PF - PA
My Team 1 - 0 - 0 - 20 - 17 Opponent 0 - 1 - 0 - 17 - 20
My goal is to do away with having to account for each outcome with the number 1 and instead use what I've been able to accomplish so far, which looks like this:
My team W 20 17 L Opponent
I've managed to accomplish that by entering the score manually and using this function:
=IF(F4>H4,"W",IF(F4<H4,"L",IF(F4=H4,"T")))
to decide if a W, L or T is to appear. The example used here is from the road team cell.
But that is where I'm stuck, ergo the question; how do I tabulate the outcomes for each team in another table where the wins are kept up to date and the same for losses and ties - each in a separate cell. I only recently began using SUMIF and COUNTIF functions, and this is the best I've managed so far (which results in #VALUE!):
=SUMIF(J2:J346,"My team",IF(I2:I346,"W","1"))
Your help will be greatly appreciated.
Hey, thanks for the suggestion. Too busy at the moment to try it. Just got home and a lot of gift wrap needs to get around some presents. Happy holidays.