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

EE | EMPLOYEE | PLANT # | 1865 | 1866 | 1867 | 1868 | 1869 | 1870 | 1871 | 1872 | 1873 | 1874 | 1875 | 1876 | 1877 | 1878 | 1879 | 1880 | 1881 | 1882 | 1887 | 1888 | 1892 | 1893 | 1895 | 1896 | 1897 A | 1897 B | 1897 C | 1897 D | 1898 | 1899 A | 1899 B | 1900 | 1905 | 1906 | 1908 A | 1909 A | 1909 B | 1910 A | 1911 A | 1918 C | 1920 C
1 | Employee Name 1 | 1
2 | Employee Name 2 | 1
3 | Employee Name 3 | 1
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16.75 | 7.75
12 | Employee Name 12 | 0
13 | Employee Name 13 | 1
14 | Employee Name 14 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.5 | 2.5
15 | Employee Name 15 | 1
16 | Employee Name 16 | 1
17 | Employee Name 17 | 1
18 | Employee Name 18 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
19 | Employee Name 19 | 1
20 | Employee Name 20 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
21 | Employee Name 21 | 1
22 | Employee Name 22 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.5 | 5.5
23 | Employee Name 23 | 1
24 | Employee Name 24 | 9
25 | Employee Name 25 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.25 |  |  |  | 5
32 | Employee Name 32 | 9
33 | Employee Name 33 | 1
34 | Employee Name 34 | 1
35 | Employee Name 35 | 8
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 |  |  |  |  |  |  |  |  |  |  |  | 5.5
45 | Employee Name 45 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17.25
46 | Employee Name 46 | 4
47 | Employee Name 47 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.25
48 | Employee Name 48 | 4
49 | Employee Name 49 | 4
50 | Employee Name 50 | 1
51 | Employee Name 51 | 2
52 | Employee Name 52 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22.75 | 3.75
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21.25
65 | Employee Name 65 | 8
66 | Employee Name 66 | 1
67 | Employee Name 67 | 1
68 | Employee Name 68 | 9
69 | Employee Name 69 | 1
70 | Employee Name 70 | 4
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17.25
76 | Employee Name 76 | 1
77 | Employee Name 77 | 1
78 | Employee Name 78 | 1
79 | Employee Name 79 | 3
80 | Employee Name 80 | 2
81 | Employee Name 81 | 1
82 | Employee Name 82 | 1
83 | Employee Name 83 | 1
84 | Employee Name 84 | 1
85 | Employee Name 85 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10.25 | 7.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
91 | Employee Name 91 | 4
92 | Employee Name 92 | 4
93 | Employee Name 93 | 4
94 | Employee Name 94 | 1
95 | Employee Name 95 | 1
96 | Employee Name 96 | 4
97 | Employee Name 97 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 14
98 | Employee Name 98 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.75 | 10.25
99 | Employee Name 99 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 10
100 | Employee Name 100 | 4
101 | Employee Name 101 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17.5
102 | Employee Name 102 | 1
103 | Employee Name 103 | 4
104 | Employee Name 104 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 1.75
105 | Employee Name 105 | 2
106 | Employee Name 106 | 1
107 | Employee Name 107 | 1
108 | Employee Name 108 | 1
109 | Employee Name 109 | 4
110 | Employee Name 110 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 8
111 | Employee Name 111 | 4
112 | Employee Name 112 | 4
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
119 | Employee Name 119 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15.5
129 | Employee Name 129 | 4
130 | Employee Name 130 | 3
131 | Employee Name 131 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17.5 | 13
132 | Employee Name 132 | 1
133 | Employee Name 133 | 3
134 | Employee Name 134 | 3
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.5 | 1.25
150 | Employee Name 150 | 1
151 | Employee Name 151 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
152 | Employee Name 152 | 1
153 | Employee Name 153 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.75 | 2.75
154 | Employee Name 154 | 2
155 | Employee Name 155 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.75
156 | Employee Name 156 | 1
157 | Employee Name 157 | 1
158 | Employee Name 158 | 1
159 | Employee Name 159 | 0
160 | Employee Name 160 | 4
161 | Employee Name 161 | 1
162 | Employee Name 162 | 1 |  |  |  |  |  |  |  |  |  | 3.5 | 2.5 | 5.5 | 3.5 | 2 | 2 | 1.5 | 2 | 5.5
163 | Employee Name 163 | 1
164 | Employee Name 164 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2.25 |  |  | 4
165 | Employee Name 165 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.25 | 0.25
166 | Employee Name 166 | 1
167 | Employee Name 167 | 1
168 | Employee Name 168 | 1
169 | Employee Name 169 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
170 | Employee Name 170 | 4
171 | Employee Name 171 | 4 |  |  |  |  |  |  |  |  | 2
172 | Employee Name 172 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
173 | Employee Name 173 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.5 | 2.5
174 | Employee Name 174 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 12.5
175 | Employee Name 175 | 1
176 | Employee Name 176 | 1
177 | Employee Name 177 | 1
178 | Employee Name 178 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 15.5
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17.25 | 3.75
191 | Employee Name 191 | 4
192 | Employee Name 192 | 4
193 | Employee Name 193 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75
194 | Employee Name 194 | 1
195 | Employee Name 195 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23.25
196 | Employee Name 196 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.5 | 8
197 | Employee Name 197 | 4
198 | Employee Name 198 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
199 | Employee Name 199 | 4
200 | Employee Name 200 | 4
201 | Employee Name 201 | 2
202 | Employee Name 202 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16.5 | 3.5
203 | Employee Name 203 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 6.25
204 | Employee Name 204 | 3
205 | Employee Name 205 | 2
206 | Employee Name 206 | 4
207 | Employee Name 207 | 4
208 | Employee Name 208 | 4
209 | Employee Name 209 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17.5
210 | Employee Name 210 | 0
211 | Employee Name 211 | 4
212 | Employee Name 212 | 1
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
220 | Employee Name 220 | 1
221 | Employee Name 221 | 2
222 | Employee Name 222 | 3