# Excel guru needed

**URL:** <https://boards.straightdope.com/t/excel-guru-needed/385690>\
**Category:** Factual Questions\
**Created:** [December 27, 2006, 1:05am UTC](https://boards.straightdope.com/t/excel-guru-needed/385690 "2006-12-27T01:05:44Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![JSexton](https://avatars.discourse-cdn.com/v4/letter/j/96bed5/32.png) [@JSexton](https://boards.straightdope.com/u/JSexton)\
**Post date:** [December 27, 2006, 1:05am UTC](https://boards.straightdope.com/t/excel-guru-needed/385690/1 "2006-12-27T01:05:44Z")

</div>

[Here’s](http://www.ticortitlenw.com/_documents/mstats2.xls) 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?

---

<div class="post-metadata">

**Author:** ![Johnny\_L.A](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/johnny_l.a/32/1084_2.png) [@Johnny\_L.A](https://boards.straightdope.com/u/Johnny_L.A)\
**Post date:** [December 27, 2006, 2:44am UTC](https://boards.straightdope.com/t/excel-guru-needed/385690/2 "2006-12-27T02:44:37Z")

</div>

[Ask the EXCEL guy …](http://boards.straightdope.com/sdmb/showthread.php?t=398567)

---

<div class="post-metadata">

**Author:** ![Improv\_Geek](https://avatars.discourse-cdn.com/v4/letter/i/b3f665/32.png) [@Improv\_Geek](https://boards.straightdope.com/u/Improv_Geek)\
**Post date:** [December 27, 2006, 2:52am UTC](https://boards.straightdope.com/t/excel-guru-needed/385690/3 "2006-12-27T02:52:06Z")

</div>

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:

```auto

=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

---

<div class="post-metadata">

**Author:** ![JSexton](https://avatars.discourse-cdn.com/v4/letter/j/96bed5/32.png) [@JSexton](https://boards.straightdope.com/u/JSexton)\
**Post date:** [December 27, 2006, 3:05pm UTC](https://boards.straightdope.com/t/excel-guru-needed/385690/4 "2006-12-27T15:05:21Z")

</div>

**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).