Okay, I've got this worksheet...
B Column has either an H (home) or an A (away) in the cell.
There's a "player" column using Columns E through N. If the player is scheduled to play, I've placed a "1" in their column so that I total across to be sure there are six players each week and then down so that each player has equal playing time.
If a player is not available, there is an "x" in the cell, so I used
=COUNTIF(E3:E20,"x") to total how many they can't play, but I can't figure out how to do this using two different columns.
So, I want Excel to look at each "1" then look for "H" (and then again for an "A") so I can count how many home games/away games each person has without worry as I juggle players.
Can I tell it to look at these cells and give me a total?
I can clarify, if needed.
Bookmarks