Here’s the spreadsheet I’m working with, which is tracking wins and losses in online mafia games. What I’d like to do is be able to not count games that didn’t finish (marked with a D on row 3) into each person’s WL percentage. So, for their Total Games (Column C), I need to be able to only count games that are not a ~ or an R in their own row (which it already does), as well as disregard games that are marked with D in row C.
I can’t figure out how to code it. Any ideas?
While I’m not the best Excel coder here, I do have a suggestion.
I’m using ‘20Bux’ as an example here. He is in 14 games, but one of those did not finish. In it he was a “T.” You would need to mark it as “DT” so you know he was on the team but the game did not end, then at the box C4 you change the code to be:
=COUNTIF(E4:AT4,"<>~") - COUNTIF(E4:AT4, "R") - COUNTIF(E4:AT4,"=DT") - COUNTIF(E4:AT4,"=DM") - COUNTIF(E4:AT4,"=DSK")
This allows you to use DT, DM and DSK to show that they held a position on a game which did not end.
That’s the best I got right now.
– IG
Improv: Thanks. I’d like something more elegant, but this works. I’ll try Johnny’s suggestion of the Excel Guy thread (duh on me).