Please see the attached spreadsheet. I want to use it to keep track of wins/losses/splits for the NFL. Well, since the
season's over, more so for a way of testing out different things to affect how the standings would come out.
question is, I want to sum wins (from the row of the table) in the AM column. Each cell that is yellow will have a
"W" or "L" in it. Each cell that is red will have a "W", "L", or "S" in
it. Is there a way of using a formula to countif the cells equal "W" to and if the cell is red to count W's as 2
and S's as 1? (Red cells represent 2 games each). I'd basically want something similar to:
Except modified to take into account the backround color. I'm not sure if this is possible, so if there's another way, I'd
love to hear it.
A second question (should it go in it's own thread?) Is there a formula that I can type into all
of the cells below the diagonal line to see if a cell mirrored across from it is a "W" to put an "L" or
vice versa? (For instance, if H4 = "W", then D8 = "L"). I know I could manually put formulas into each
cell, but that would take a while and was wondering if the experts on here could help.