I'm embarassed to say I found the perfect solution on Chandoo yesterday, but didn't save it. Argh.
A B C
1
2
3 Team Company Win/Loss
4 East ABC W
5 West DEF L
6 South HIJ
7 East XYZ L
8 South LMN W
9 West ZYX L
10 North QRS W
I need a formula in C1 that returns the number of...