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

EE | EMPLOYEE | PLANT # | 1869 | 1870 | 1871 | 1872 | 1873 | 1874 | 1875 | 1876 | 1877 | 1878 | 1879 | 1880 | 1881 | 1882 | 1887 | 1888 | 1889 | 1892 | 1893 | 1894 | 1895 | 1896 | 1897 A | 1897 B | 1897 C | 1897 D | 1898 | 1899 A | 1899 B | 1900 | 1905 | 1906 | 1908 A | 1908 B | 1909 A | 1909 B | 1910 A | 1916 | 1917 A | 1918 B | 1918 C | 1919 A | 1920 B | 1920 C | 1922 B | 1922 C | 1924 B | 1924 C | 1928 C
1 | Employee Name 1 | 1
2 | Employee Name 2 | 1 |  |  |  |  |  |  |  |  |  |  | 1
3 | Employee Name 3 | 1 |  |  |  |  |  |  |  |  |  |  | 6
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
10 | Employee Name 10 | 4 | 4
11 | Employee Name 11 | 1
12 | Employee Name 12 | 0
13 | Employee Name 13 | 1
14 | Employee Name 14 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
15 | Employee Name 15 | 1 |  |  |  |  |  |  |  |  |  |  | 7
16 | Employee Name 16 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10.5
17 | Employee Name 17 | 1
18 | Employee Name 18 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 14
19 | Employee Name 19 | 1 |  |  |  |  |  |  |  |  |  |  | 12 |  |  |  | 4 | 4
20 | Employee Name 20 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.25
21 | Employee Name 21 | 1
22 | Employee Name 22 | 2 |  |  |  |  |  |  |  |  |  |  | 4.5
23 | Employee Name 23 | 1
24 | Employee Name 24 | 9
25 | Employee Name 25 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.5 | 8
26 | Employee Name 26 | 4 | 6
27 | Employee Name 27 | 4
28 | Employee Name 28 | 4
29 | Employee Name 29 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.5 | 2
30 | Employee Name 30 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18.25 | 8.75
31 | Employee Name 31 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.25
32 | Employee Name 32 | 9
33 | Employee Name 33 | 1
34 | Employee Name 34 | 1 |  |  |  |  |  |  |  |  |  |  | 24
35 | Employee Name 35 | 8
36 | Employee Name 36 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5
46 | Employee Name 46 | 4
47 | Employee Name 47 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 2.75
48 | Employee Name 48 | 4 |  |  |  |  |  | 10.75
49 | Employee Name 49 | 4
50 | Employee Name 50 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.75
51 | Employee Name 51 | 2 |  |  |  |  |  |  |  |  |  |  | 8.5 |  | 7.5
52 | Employee Name 52 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 4 |  |  |  |  | 10.5
53 | Employee Name 53 | 1 |  |  |  |  |  |  |  |  |  |  | 6.25
54 | Employee Name 54 | 2
55 | Employee Name 55 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
56 | Employee Name 56 | 9
57 | Employee Name 57 | 1
58 | Employee Name 58 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
59 | Employee Name 59 | 2
60 | Employee Name 60 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.75
61 | Employee Name 61 | 4
62 | Employee Name 62 | 1 |  |  |  |  |  |  |  |  |  |  | 10.5
63 | Employee Name 63 | 1
64 | Employee Name 64 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15.25
65 | Employee Name 65 | 8
66 | Employee Name 66 | 1
67 | Employee Name 67 | 1
68 | Employee Name 68 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
69 | Employee Name 69 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 16
70 | Employee Name 70 | 4
71 | Employee Name 71 | 4
72 | Employee Name 72 | 0 |  |  |  |  |  |  |  |  |  |  | 9
73 | Employee Name 73 | 1
74 | Employee Name 74 | 1 | 0.5 |  |  |  |  |  |  |  |  |  | 0.5
75 | Employee Name 75 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15.25
76 | Employee Name 76 | 1
77 | Employee Name 77 | 1
78 | Employee Name 78 | 1
79 | Employee Name 79 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 3
80 | Employee Name 80 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22.5 | 6
81 | Employee Name 81 | 1
82 | Employee Name 82 | 1 |  |  |  |  |  |  |  |  |  |  | 0.5 |  |  |  | 8
83 | Employee Name 83 | 1 |  |  |  |  |  |  |  |  |  |  | 7.5
84 | Employee Name 84 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.5 | 3.25
85 | Employee Name 85 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.5
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 |  |  |  |  |  |  |  |  |  |  | 3
92 | Employee Name 92 | 4 |  |  |  |  |  |  |  |  | 18 |  | 4
93 | Employee Name 93 | 4 |  |  |  |  |  |  |  |  |  |  | 12.75
94 | Employee Name 94 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21.5
102 | Employee Name 102 | 1
103 | Employee Name 103 | 4
104 | Employee Name 104 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.25 | 7.5
105 | Employee Name 105 | 2 | 12
106 | Employee Name 106 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.25 | 8.75
107 | Employee Name 107 | 1 |  |  |  |  |  |  |  |  |  |  | 2.5
108 | Employee Name 108 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10.75 | 6
109 | Employee Name 109 | 4
110 | Employee Name 110 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5.75 |  | 4 | 5.75 |  | 2.5
111 | Employee Name 111 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.75
112 | Employee Name 112 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 17.5
113 | Employee Name 113 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.5
114 | Employee Name 114 | 4
115 | Employee Name 115 | 4 |  |  |  |  |  |  |  |  |  |  | 1.75
116 | Employee Name 116 | 2
117 | Employee Name 117 | 9 | 13
118 | Employee Name 118 | 4
119 | Employee Name 119 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.5 |  |  |  |  |  |  |  |  |  |  | 4 | 2 | 3 |  |  | 2.5 |  | 2.5
120 | Employee Name 120 | 3
121 | Employee Name 121 | 1
122 | Employee Name 122 | 1 |  |  |  |  |  |  |  |  |  |  | 5.75 |  |  |  |  | 5
123 | Employee Name 123 | 1
124 | Employee Name 124 | 1 |  |  |  |  |  |  |  |  |  |  | 7
125 | Employee Name 125 | 1
126 | Employee Name 126 | 1
127 | Employee Name 127 | 3
128 | Employee Name 128 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.5
129 | Employee Name 129 | 4
130 | Employee Name 130 | 3
131 | Employee Name 131 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
132 | Employee Name 132 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
133 | Employee Name 133 | 3
134 | Employee Name 134 | 3
135 | Employee Name 135 | 3 |  |  |  |  |  |  |  |  |  |  | 16
136 | Employee Name 136 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.75 | 9.25
145 | Employee Name 145 | 1
146 | Employee Name 146 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 2.75
147 | Employee Name 147 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14.5
148 | Employee Name 148 | 1
149 | Employee Name 149 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.75 | 1.25 |  | 1.25 |  | 1.5
150 | Employee Name 150 | 1
151 | Employee Name 151 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
152 | Employee Name 152 | 1
153 | Employee Name 153 | 1
154 | Employee Name 154 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.5
155 | Employee Name 155 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 5
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 |  |  |  |  |  |  |  |  |  |  | 4.5 |  |  |  | 5 | 1.5
162 | Employee Name 162 | 1 |  |  |  |  |  |  |  |  |  | 3 | 4.5 |  |  |  | 5 | 1.5 |  |  | 3 |  |  |  | 4.5 | 3.5 | 6.5 | 0.5
163 | Employee Name 163 | 1
164 | Employee Name 164 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.5 | 1.5 | 3.5 |  |  |  |  |  |  |  | 2 |  | 3.25 | 1.75 |  | 0.5 | 2.5
165 | Employee Name 165 | 1
166 | Employee Name 166 | 1
167 | Employee Name 167 | 1
168 | Employee Name 168 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.5 | 5
169 | Employee Name 169 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 3.5
170 | Employee Name 170 | 4
171 | Employee Name 171 | 4 |  |  |  |  |  |  |  |  |  |  | 11.5
172 | Employee Name 172 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
173 | Employee Name 173 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.75 |  | 2
174 | Employee Name 174 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
175 | Employee Name 175 | 1
176 | Employee Name 176 | 1
177 | Employee Name 177 | 1
178 | Employee Name 178 | 1 |  |  |  |  |  |  |  |  |  |  | 0.5
179 | Employee Name 179 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
180 | Employee Name 180 | 1 |  |  |  |  |  |  |  |  |  |  | 1.25 |  |  |  |  | 9.75
181 | Employee Name 181 | 4 |  |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 5
182 | Employee Name 182 | 1 |  |  |  |  |  |  |  |  |  |  | 6.25
183 | Employee Name 183 | 1
184 | Employee Name 184 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 4
185 | Employee Name 185 | 1
186 | Employee Name 186 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 10
187 | Employee Name 187 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 3
188 | Employee Name 188 | 1 |  |  |  |  |  |  |  |  |  |  | 1.5
189 | Employee Name 189 | 1
190 | Employee Name 190 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
191 | Employee Name 191 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.5
192 | Employee Name 192 | 4
193 | Employee Name 193 | 4
194 | Employee Name 194 | 1
195 | Employee Name 195 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.25
196 | Employee Name 196 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
197 | Employee Name 197 | 4 |  |  |  |  |  |  |  |  |  |  | 3
198 | Employee Name 198 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
199 | Employee Name 199 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.5
200 | Employee Name 200 | 4
201 | Employee Name 201 | 2
202 | Employee Name 202 | 4
203 | Employee Name 203 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 5
204 | Employee Name 204 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16.5
205 | Employee Name 205 | 2
206 | Employee Name 206 | 4
207 | Employee Name 207 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
208 | Employee Name 208 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  | 6
209 | Employee Name 209 | 0
210 | Employee Name 210 | 0
211 | Employee Name 211 | 4 | 20.5 |  | 19.5
212 | Employee Name 212 | 1
213 | Employee Name 213 | 3 |  |  |  |  |  |  |  |  |  |  | 8
214 | Employee Name 214 | 0
215 | Employee Name 215 | 9 |  |  |  |  |  |  |  |  |  |  | 1.5
216 | Employee Name 216 | 3 | 6.25
217 | Employee Name 217 | 1
218 | Employee Name 218 | 1
219 | Employee Name 219 | 4 |  |  |  |  |  |  |  |  |  |  | 13
220 | Employee Name 220 | 1 |  |  |  |  |  |  |  |  |  |  | 12
221 | Employee Name 221 | 2
222 | Employee Name 222 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.75 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 11 |  |  |  |  |  |  | 1.5 |  | 2.25 |  | 11 |  |  | 3.5 |  | 1.5 |  | 1.5