Spreadsheet: 49574d1248936899-excel-2007-counting-cells-pertaining-to-other-cells-testsheet
Sheet: Sheet1

 |  | 9gLancers T-Shirts
 | Member [NAME] | Shirt Color | Small | Medium | Large | X Large | XX Large | XXX Large | BC?
1 | tatsujo | Black |  |  | 1
2 | tatsujo | White |  |  | 1
3 | 9gL | White |  | 1
4 | Novadreams | Blue |  |  |  |  | 1
5 | 09lancerguy | Black |  |  | 1
6 | 09lancerguy | Black |  |  | 1
7 | 09lancerguy | White |  |  | 1
8 | skrewed4ever | White |  | 1
9 | wewalkalone87 | Black |  |  |  |  | 1
10 | wewalkalone87 | Black |  |  |  |  | 1
11 | wewalkalone87 | White |  |  |  |  | 1
12 | wewalkalone87 | Blue |  |  |  |  | 1
13 | wewalkalone87 | Black | 1
14 | orlandors764 | Black |  |  |  |  | 1
15 | beyonddc | White |  |  |  | 1 |  |  | x
16 | beyonddc | Orange |  |  |  | 1
17 | mayen2000 | White |  |  | 1
18 | [NAME] | Black |  |  | 1 |  |  |  | x
19 | muddy014 | Red |  |  |  | 1
20 | kaotikkaos | Black | 1
21 | aznboi281 | Blue |  |  | 1
22 | aznboi281 | White |  |  | 1
23 | swamps420 | Gray |  |  |  |  | 1
24 | swamps420 | White |  |  |  |  | 1
25 | hadeswolf | White |  |  | 1
26 | liquid_94 | Gray |  | 1
27 | chelito_ska | Black |  |  | 1
28 | alberto_sn | Red |  |  |  | 1
29 | volcomston3d | Orange | 1 |  |  |  |  |  | x
30 | volcomston3d | Blue | 1
31 | [NAME] | Black |  | 1
32 | ROTHEEE | Blue |  | 1
33 | ROTHEEE | Black |  | 1
34 | riveraj765 | Black | 1
35 | Think_411 | Blue |  | 1
36 | Black Night 17 | Black |  |  | 1
37 | ckrajcer | Gray |  |  |  | 1
38 | johnmercury007 | Black |  |  | 1
39 | SteinhauerLL | White |  |  | 1
40 | icedtc | Gray |  |  | 1
41 | wiredblade | Black |  | 1
42 | wiredblade | White |  | 1
43 | [NAME] | Black |  |  | 1
44 | [NAME] | Blue |  | 1
45 | bigEC | Black |  |  | 1
46 | RR09GTS | Black |  |  |  |  | 1
47 | RR09GTS | White |  |  |  |  | 1
48 | kingsknight3110 | Black |  |  |  | 1
49 | dpomp | Gray |  |  | 1 |  |  |  | x
50 | alias710 | White |  |  |  | 1
51 | alias710 | Black |  |  |  | 1
52 | Answer | Black |  | 1
53 | Answer | Gray |  | 1
54 | rgdft | Black |  |  |  |  |  | 1
55 | rgdft | Orange |  |  |  |  |  | 1
56 | Ico | Black |  |  | 1
57 | aznbbreaker07 | White |  |  | 1
58 | aznbbreaker07 | Black |  |  | 1
59 | cameron.jurkowski | White |  | 1
60 | cameron.jurkowski | Black |  | 1
61 | cameron.jurkowski | Gray |  | 1
62 | srtlancer08 | White |  |  | 1
63 | srtlancer08 | Black |  |  | 1
64 | srtlancer08 | Gray |  |  | 1
65 | EXECUTIONER | Black |  |  |  |  | 1
66 | EXECUTIONER | Red |  |  |  |  | 1
67 | Irresistable | Black |  |  | 1
68 | LogicGTS | BLack |  |  |  | 1 |  |  | x
69 | LogicGTS | Gray |  |  |  | 1
70 | [NAME] | Black |  | 1
71 | [NAME] | Gray |  | 1
72 | waiting89 | Black | 1
73 | waiting89 | White | 1
74 | flambouyantdude | Black |  | 1
75 | thecoldwindblows | Black |  | 1
76 | ashrod89 | Black |  |  | 1
77 | Trust | White |  |  |  |  | 1
78 | Trust | Black |  |  |  |  | 1
79 | fula210 | Black |  |  | 1
80 | bluegts09 | White | 1
81 | bluegts09 | Black | 1
82 | 09GTSLancer | White |  |  |  |  | 1
83 | [NAME] | Black |  | 1
84 | [NAME] | Orange |  | 1
85 | cRc 22 | White |  |  | 1
86 | cRc 22 | Black |  |  | 1
87 | 4b11Bobcat | Black |  |  | 1
88 | steveo420extreme | Gray |  |  |  | 1
89 | EVO_VIII | Blue |  | 1
90 | EVO_VIII | Blue |  | 1
91 | derek984 | Black | 1
92 | jason_solt | White |  |  | 1
93 | asianuncstudent | Black |  |  | 1
94 | asianuncstudent | Red |  |  | 1
95 | vietsk8r901 | Blue | 1
96 | jooks67 | White |  |  |  | 1 |  |  | x
97 | jooks67 | Black |  |  |  | 1
98 | jooks67 | Gray |  |  |  | 1
99 | jooks67 | Blue |  |  |  | 1
100 | jooks67 | Red |  |  |  | 1
101 | jooks67 | Orange |  |  |  | 1
102 | webzes | White |  |  | 1
103 | webzes | Black |  |  | 1
104 | webzes | Red |  |  | 1
105 | gts-sb | White |  |  |  | 1
106 | gts-sb | Blue |  |  |  | 1
107 | hmoobher | Black |  |  | 1
 |  |  | TOTAL | TOTAL | TOTAL | TOTAL | TOTAL | TOTAL
 |  | Shirt Color | Small | Medium | Large | X Large | XX Large | XXX Large
 | WHITE |  | 2 | 4 | 11 | 5 | 4
 | BLACK |  | 7 | 9 | 20 | 3 | 6 | 1
 | GRAY |  |  | 4 | 3 | 4 | 1
 | RED |  |  |  | 2 | 3 | 1
 | BLUE |  | 1 | 5 | 1 | 2 | 3
 | ORANGE |  | 1 | 1 |  | 2 |  | 1
 |  |  | TOTAL |  |  | TOTAL