Spreadsheet: 150046d1334257801-excel-2007-sumproduct-across-multiple-worksheets-value-error-sample2
Sheet: F11F17REG

EE | EMPLOYEE | PLANT # | 1874 | 1875 | 1876 | 1877 | 1878 | 1879 | 1880 | 1881 | 1882 | 1883 | 1887 | 1888 | 1889 | 1890 | 1892 | 1893 | 1894 | 1895 | 1896 | 1897 A | 1897 B | 1897 C | 1897 D | 1898 | 1899 A | 1899 B | 1900 | 1901 | 1904 | 1905 | 1906 | 1908 A | 1908 B | 1909 A | 1910 A | 1910 B | 1916 | 1917 A | 1918 B | 1918 C | 1919 A | 1920 B | 1920 C | 1921 A | 1922 B | 1922 C | 1923 A | 1924 B | 1924 C | 1926 C | 1928 C | 1938 C | 1940 C | 1942 C | 1943 A | 1944 C | 1960 | 1961 | 1980 A | 1999 C | 2001 C | 2004
1 | Employee Name 1 | 1
2 | Employee Name 2 | 1
3 | Employee Name 3 | 1 |  |  |  |  |  |  |  |  |  |  | 18
4 | Employee Name 4 | 0
5 | Employee Name 5 | 1
6 | Employee Name 6 | 2
7 | Employee Name 7 | 4
8 | Employee Name 8 | 3
9 | Employee Name 9 | 4
10 | Employee Name 10 | 4
11 | Employee Name 11 | 1
12 | Employee Name 12 | 0
13 | Employee Name 13 | 1
14 | Employee Name 14 | 2
15 | Employee Name 15 | 1 |  |  |  |  |  |  |  |  |  |  | 18
16 | Employee Name 16 | 1
17 | Employee Name 17 | 1
18 | Employee Name 18 | 1
19 | Employee Name 19 | 1
20 | Employee Name 20 | 1
21 | Employee Name 21 | 1
22 | Employee Name 22 | 2
23 | Employee Name 23 | 1 |  |  |  |  |  |  |  |  |  |  |  | 3
24 | Employee Name 24 | 9
25 | Employee Name 25 | 1
26 | Employee Name 26 | 4
27 | Employee Name 27 | 4
28 | Employee Name 28 | 4
29 | Employee Name 29 | 2
30 | Employee Name 30 | 1
31 | Employee Name 31 | 1
32 | Employee Name 32 | 9
33 | Employee Name 33 | 1
34 | Employee Name 34 | 1 |  |  |  |  |  |  |  |  |  |  |  | 5.5
35 | Employee Name 35 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.75 | 2.75 |  | 2.75 | 2.75
36 | Employee Name 36 | 1
37 | Employee Name 37 | 0
38 | Employee Name 38 | 1
39 | Employee Name 39 | 1
40 | Employee Name 40 | 1
41 | Employee Name 41 | 8
42 | Employee Name 42 | 1
43 | Employee Name 43 | 0
44 | Employee Name 44 | 1
45 | Employee Name 45 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
46 | Employee Name 46 | 4
47 | Employee Name 47 | 4
48 | Employee Name 48 | 4
49 | Employee Name 49 | 4
50 | Employee Name 50 | 1 |  |  |  |  |  |  |  |  |  |  | 8 | 6.75
51 | Employee Name 51 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.5 |  | 6.5
52 | Employee Name 52 | 4
53 | Employee Name 53 | 1
54 | Employee Name 54 | 2
55 | Employee Name 55 | 4
56 | Employee Name 56 | 9
57 | Employee Name 57 | 1
58 | Employee Name 58 | 9
59 | Employee Name 59 | 2
60 | Employee Name 60 | 9
61 | Employee Name 61 | 4
62 | Employee Name 62 | 1
63 | Employee Name 63 | 1
64 | Employee Name 64 | 1
65 | Employee Name 65 | 8 |  |  |  |  |  |  |  |  |  |  |  | 8
66 | Employee Name 66 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.5 | 2.5
67 | Employee Name 67 | 1 |  |  |  |  |  |  |  |  |  |  |  | 7.75 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
68 | Employee Name 68 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
69 | Employee Name 69 | 1
70 | Employee Name 70 | 4 |  |  |  |  |  |  |  |  |  |  | 4.25
71 | Employee Name 71 | 4
72 | Employee Name 72 | 0
73 | Employee Name 73 | 1
74 | Employee Name 74 | 1
75 | Employee Name 75 | 2
76 | Employee Name 76 | 1
77 | Employee Name 77 | 1
78 | Employee Name 78 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
79 | Employee Name 79 | 3
80 | Employee Name 80 | 2
81 | Employee Name 81 | 1
82 | Employee Name 82 | 1 |  |  |  |  |  |  |  |  |  |  | 4 | 8.75
83 | Employee Name 83 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 5
84 | Employee Name 84 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.5 |  |  |  |  |  |  | 2.5 |  |  | 7 |  |  |  |  |  |  |  |  |  | 11.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.5
85 | Employee Name 85 | 4 |  |  |  |  |  |  |  |  |  |  | 1.5 | 3.25
86 | Employee Name 86 | 3
87 | Employee Name 87 | 4
88 | Employee Name 88 | 4
89 | Employee Name 89 | 4
90 | Employee Name 90 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3
91 | Employee Name 91 | 4
92 | Employee Name 92 | 4
93 | Employee Name 93 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
94 | Employee Name 94 | 1
95 | Employee Name 95 | 1
96 | Employee Name 96 | 4
97 | Employee Name 97 | 4
98 | Employee Name 98 | 4
99 | Employee Name 99 | 1
100 | Employee Name 100 | 4
101 | Employee Name 101 | 4
102 | Employee Name 102 | 1
103 | Employee Name 103 | 4
104 | Employee Name 104 | 2
105 | Employee Name 105 | 2
106 | Employee Name 106 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
107 | Employee Name 107 | 1
108 | Employee Name 108 | 1
109 | Employee Name 109 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.75 | 6.75 | 6.5
110 | Employee Name 110 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75
111 | Employee Name 111 | 4
112 | Employee Name 112 | 4 |  |  |  |  |  |  |  |  |  |  | 1.25 | 4.25
113 | Employee Name 113 | 2
114 | Employee Name 114 | 4
115 | Employee Name 115 | 4
116 | Employee Name 116 | 2
117 | Employee Name 117 | 9
118 | Employee Name 118 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.5
119 | Employee Name 119 | 3
120 | Employee Name 120 | 3
121 | Employee Name 121 | 1
122 | Employee Name 122 | 1
123 | Employee Name 123 | 1
124 | Employee Name 124 | 1
125 | Employee Name 125 | 1
126 | Employee Name 126 | 1
127 | Employee Name 127 | 3
128 | Employee Name 128 | 4
129 | Employee Name 129 | 4
130 | Employee Name 130 | 3
131 | Employee Name 131 | 3
132 | Employee Name 132 | 1
133 | Employee Name 133 | 3
134 | Employee Name 134 | 3 |  |  |  |  |  |  |  | 1.5
135 | Employee Name 135 | 3
136 | Employee Name 136 | 4
137 | Employee Name 137 | 1
138 | Employee Name 138 | 1
139 | Employee Name 139 | 1
140 | Employee Name 140 | 1
141 | Employee Name 141 | 1
142 | Employee Name 142 | 1
143 | Employee Name 143 | 1
144 | Employee Name 144 | 1
145 | Employee Name 145 | 1
146 | Employee Name 146 | 1
147 | Employee Name 147 | 1
148 | Employee Name 148 | 1
149 | Employee Name 149 | 1
150 | Employee Name 150 | 1
151 | Employee Name 151 | 1
152 | Employee Name 152 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.5
153 | Employee Name 153 | 1
154 | Employee Name 154 | 2
155 | Employee Name 155 | 4
156 | Employee Name 156 | 1
157 | Employee Name 157 | 1
158 | Employee Name 158 | 1
159 | Employee Name 159 | 0 |  |  |  |  |  |  |  |  |  |  | 3.5
160 | Employee Name 160 | 4 |  |  |  |  |  |  |  |  |  |  | 3.5 | 5
161 | Employee Name 161 | 1
162 | Employee Name 162 | 1
163 | Employee Name 163 | 1
164 | Employee Name 164 | 3
165 | Employee Name 165 | 1
166 | Employee Name 166 | 1
167 | Employee Name 167 | 1
168 | Employee Name 168 | 1
169 | Employee Name 169 | 4
170 | Employee Name 170 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.75
171 | Employee Name 171 | 4
172 | Employee Name 172 | 1 |  |  |  |  |  |  |  |  |  |  | 2
173 | Employee Name 173 | 1
174 | Employee Name 174 | 1
175 | Employee Name 175 | 1
176 | Employee Name 176 | 1
177 | Employee Name 177 | 1
178 | Employee Name 178 | 1
179 | Employee Name 179 | 4
180 | Employee Name 180 | 1
181 | Employee Name 181 | 4
182 | Employee Name 182 | 1
183 | Employee Name 183 | 1
184 | Employee Name 184 | 1
185 | Employee Name 185 | 1
186 | Employee Name 186 | 0
187 | Employee Name 187 | 4
188 | Employee Name 188 | 1
189 | Employee Name 189 | 1
190 | Employee Name 190 | 3
191 | Employee Name 191 | 4
192 | Employee Name 192 | 4
193 | Employee Name 193 | 4
194 | Employee Name 194 | 1
195 | Employee Name 195 | 4 |  |  |  |  |  |  |  |  |  |  |  | 11.75
196 | Employee Name 196 | 4
197 | Employee Name 197 | 4
198 | Employee Name 198 | 4
199 | Employee Name 199 | 4
200 | Employee Name 200 | 4
201 | Employee Name 201 | 2
202 | Employee Name 202 | 4
203 | Employee Name 203 | 4
204 | Employee Name 204 | 3
205 | Employee Name 205 | 2
206 | Employee Name 206 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.25
207 | Employee Name 207 | 4
208 | Employee Name 208 | 4
209 | Employee Name 209 | 0
210 | Employee Name 210 | 0
211 | Employee Name 211 | 4
212 | Employee Name 212 | 1 |  |  |  |  |  |  |  |  |  |  |  | 1.75
213 | Employee Name 213 | 3
214 | Employee Name 214 | 0
215 | Employee Name 215 | 9
216 | Employee Name 216 | 3
217 | Employee Name 217 | 1
218 | Employee Name 218 | 1
219 | Employee Name 219 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
220 | Employee Name 220 | 1
221 | Employee Name 221 | 2 |  |  |  |  |  |  |  |  |  |  |  | 6.25
222 | Employee Name 222 | 3