Spreadsheet: 33932d1230863267-array-formula-or-similar-needed-again-book1
Sheet: Sheet1

 | 1st Quarter |  |  |  |  |  |  |  |  |  | 2nd Quarter |  |  |  |  |  |  |  |  |  | 3rd Quarter |  |  |  |  |  |  |  |  |  | 4th Quarter |  |  |  |  |  |  |  |  |  | Year-to-date
Desc. | 2009-01-31 00:00:00 | Budget | 2009-02-28 00:00:00 | Budget | 2009-03-31 00:00:00 | Budget | Total | Budget | [NAME] | Var. % | 2009-04-30 00:00:00 | Budget | 2009-05-31 00:00:00 | Budget | 2009-06-30 00:00:00 | Budget | Total | Budget | [NAME] | Var. % | 2009-07-31 00:00:00 | Budget | 2009-08-31 00:00:00 | Budget | 2009-09-30 00:00:00 | Budget | Total | Budget | [NAME] | Var. % | 2009-10-31 00:00:00 | Budget | 2009-11-30 00:00:00 | Budget | 2009-12-31 00:00:00 | Budget | Total | Budget | [NAME] | Var. % | Total | Budget | [NAME] | Var. %
1 | 107 | 85 | 118 | 114 | 111 | 120 | 336 | 319 |  |  | 98 | 88 | 88 | 90 | 92 | 100 | 278 | 278 |  |  | 119 | 107 | 95 | 90 | 104 | 80 | 318 | 277 |  |  | 83 | 116 | 83 | 112 | 102 | 108 | 268 | 336 |  |  |  | 407
2 | 111 | 84 | 102 | 108 | 93 | 116 | 306 | 308 |  |  | 114 | 101 | 105 | 96 | 97 | 112 | 316 | 309 |  |  | 112 | 120 | 116 | 82 | 86 | 101 | 314 | 303 |  |  | 118 | 106 | 83 | 92 | 101 | 116 | 302 | 314
3 | 105 | 101 | 82 | 101 | 90 | 119 | 277 | 321 |  |  | 96 | 91 | 84 | 92 | 101 | 94 | 281 | 277 |  |  | 105 | 108 | 107 | 108 | 96 | 80 | 308 | 296 |  |  | 112 | 118 | 101 | 101 | 113 | 95 | 326 | 314
4 | 81 | 84 | 107 | 110 | 108 | 112 | 296 | 306 |  |  | 94 | 101 | 85 | 84 | 110 | 106 | 289 | 291 |  |  | 89 | 112 | 84 | 95 | 117 | 92 | 290 | 299 |  |  | 99 | 109 | 84 | 112 | 102 | 102 | 285 | 323
5 | 82 | 113 | 99 | 120 | 118 | 87 | 299 | 320 |  |  | 111 | 101 | 96 | 90 | 103 | 120 | 310 | 311 |  |  | 97 | 95 | 102 | 116 | 84 | 87 | 283 | 298 |  |  | 82 | 110 | 119 | 97 | 119 | 113 | 320 | 320
6 | 83 | 81 | 94 | 106 | 119 | 88 | 296 | 275 |  |  | 81 | 94 | 85 | 117 | 91 | 85 | 257 | 296 |  |  | 84 | 82 | 106 | 115 | 110 | 118 | 300 | 315 |  |  | 112 | 120 | 83 | 111 | 101 | 118 | 296 | 349
7 | 120 | 80 | 114 | 86 | 116 | 118 | 350 | 284 |  |  | 95 | 106 | 93 | 93 | 104 | 94 | 292 | 293 |  |  | 119 | 86 | 98 | 80 | 120 | 95 | 337 | 261 |  |  | 91 | 118 | 103 | 115 | 111 | 100 | 305 | 333
8 | 109 | 100 | 89 | 107 | 114 | 84 | 312 | 291 |  |  | 101 | 87 | 114 | 103 | 115 | 85 | 330 | 275 |  |  | 110 | 106 | 87 | 119 | 105 | 84 | 302 | 309 |  |  | 88 | 98 | 84 | 97 | 103 | 108 | 275 | 303
9 | 116 | 93 | 85 | 87 | 116 | 95 | 317 | 275 |  |  | 117 | 83 | 91 | 111 | 109 | 87 | 317 | 281 |  |  | 82 | 104 | 84 | 115 | 114 | 114 | 280 | 333 |  |  | 93 | 112 | 111 | 93 | 106 | 120 | 310 | 325
10 | 104 | 114 | 100 | 108 | 98 | 99 | 302 | 321 |  |  | 120 | 107 | 85 | 106 | 119 | 87 | 324 | 300 |  |  | 111 | 105 | 116 | 118 | 113 | 101 | 340 | 324 |  |  | 120 | 120 | 119 | 105 | 117 | 90 | 356 | 315
11 | 102 | 114 | 97 | 111 | 104 | 113 | 303 | 338 |  |  | 112 | 82 | 111 | 111 | 98 | 87 | 321 | 280 |  |  | 95 | 86 | 90 | 81 | 107 | 91 | 292 | 258 |  |  | 110 | 96 | 98 | 82 | 84 | 116 | 292 | 294
12 | 101 | 86 | 105 | 109 | 88 | 111 | 294 | 306 |  |  | 90 | 110 | 88 | 91 | 86 | 105 | 264 | 306 |  |  | 107 | 85 | 95 | 112 | 90 | 109 | 292 | 306 |  |  | 112 | 104 | 116 | 90 | 81 | 87 | 309 | 281
13 | 103 | 109 | 117 | 110 | 90 | 92 | 310 | 311 |  |  | 92 | 115 | 81 | 80 | 106 | 99 | 279 | 294 |  |  | 116 | 120 | 116 | 120 | 111 | 104 | 343 | 344 |  |  | 96 | 80 | 109 | 112 | 83 | 104 | 288 | 296
14 | 94 | 81 | 84 | 90 | 94 | 116 | 272 | 287 |  |  | 110 | 93 | 118 | 94 | 106 | 116 | 334 | 303 |  |  | 102 | 103 | 101 | 112 | 103 | 91 | 306 | 306 |  |  | 94 | 108 | 82 | 101 | 82 | 94 | 258 | 303
15 | 119 | 114 | 80 | 103 | 97 | 85 | 296 | 302 |  |  | 110 | 106 | 82 | 107 | 120 | 117 | 312 | 330 |  |  | 120 | 100 | 119 | 96 | 114 | 107 | 353 | 303 |  |  | 83 | 83 | 85 | 84 | 106 | 104 | 274 | 271
16 | 109 | 109 | 119 | 88 | 120 | 96 | 348 | 293 |  |  | 90 | 99 | 107 | 109 | 109 | 91 | 306 | 299 |  |  | 102 | 118 | 100 | 114 | 86 | 98 | 288 | 330 |  |  | 97 | 81 | 109 | 109 | 110 | 90 | 316 | 280
17 | 92 | 115 | 112 | 112 | 116 | 117 | 320 | 344 |  |  | 93 | 112 | 95 | 104 | 88 | 96 | 276 | 312 |  |  | 81 | 98 | 115 | 102 | 115 | 90 | 311 | 290 |  |  | 85 | 82 | 101 | 108 | 82 | 91 | 268 | 281
18 | 81 | 113 | 98 | 102 | 86 | 110 | 265 | 325 |  |  | 109 | 96 | 83 | 111 | 84 | 103 | 276 | 310 |  |  | 100 | 102 | 99 | 97 | 84 | 104 | 283 | 303 |  |  | 115 | 81 | 90 | 88 | 93 | 113 | 298 | 282
19 | 93 | 113 | 95 | 86 | 91 | 86 | 279 | 285 |  |  | 115 | 88 | 88 | 113 | 82 | 95 | 285 | 296 |  |  | 91 | 109 | 108 | 88 | 91 | 109 | 290 | 306 |  |  | 107 | 82 | 118 | 80 | 82 | 96 | 307 | 258
20 | 94 | 118 | 82 | 83 | 116 | 100 | 292 | 301 |  |  | 110 | 94 | 108 | 103 | 95 | 93 | 313 | 290 |  |  | 115 | 108 | 97 | 90 | 111 | 109 | 323 | 307 |  |  | 93 | 81 | 87 | 108 | 118 | 99 | 298 | 288
21 | 88 | 98 | 99 | 109 | 120 | 91 | 307 | 298 |  |  | 99 | 83 | 114 | 109 | 91 | 112 | 304 | 304 |  |  | 105 | 95 | 101 | 87 | 117 | 100 | 323 | 282 |  |  | 111 | 98 | 91 | 96 | 81 | 99 | 283 | 293
22 | 107 | 94 | 114 | 88 | 97 | 93 | 318 | 275 |  |  | 101 | 114 | 100 | 95 | 80 | 108 | 281 | 317 |  |  | 107 | 88 | 120 | 113 | 113 | 99 | 340 | 300 |  |  | 117 | 113 | 99 | 84 | 117 | 109 | 333 | 306
23 | 113 | 84 | 118 | 80 | 81 | 108 | 312 | 272 |  |  | 103 | 88 | 93 | 95 | 81 | 105 | 277 | 288 |  |  | 87 | 103 | 93 | 83 | 88 | 80 | 268 | 266 |  |  | 104 | 119 | 101 | 104 | 86 | 111 | 291 | 334 |  |  |  | 360
24 | 112 | 89 | 82 | 89 | 120 | 110 | 314 | 288 |  |  | 82 | 87 | 112 | 113 | 84 | 111 | 278 | 311 |  |  | 80 | 115 | 85 | 106 | 114 | 113 | 279 | 334 |  |  | 93 | 105 | 109 | 94 | 94 | 81 | 296 | 280 |  |  |  | 375
25 | 83 | 90 | 84 | 111 | 90 | 115 | 257 | 316 |  |  | 82 | 84 | 88 | 104 | 119 | 82 | 289 | 270 |  |  | 82 | 118 | 109 | 110 | 99 | 104 | 290 | 332 |  |  | 104 | 80 | 105 | 108 | 92 | 95 | 301 | 283 |  |  |  | 400
Problem: | Summarise the values in the rows 4:28 in the columns with a  'date' headings (row 3) according to which classifciation they fall under (A36:B61) and populate the cells with a "?"
Black | ? |  | ? |  | ? |  |  |  |  |  | ? |  | ? |  | ?
Green | ? |  | ? |  | ? |  |  |  |  |  | ? |  | ? |  | ?
Blue | ? |  | ? |  | ? |  |  |  |  |  | ? |  | ? |  | ?
1 | Black |  |  | 2509 |  | 1192
2 | Black |  |  | 1185 |  | 1167
3 | Blue
4 | Black
5 | Green
6 | Green
7 | Black
8 | Black
9 | Blue
10 | Blue
11 | Green
12 | Green
13 | Green
14 | Green
15 | Black
16 | Black
17 | Blue
18 | Green
19 | Green
20 | Green
21 | Green
22 | Green
23 | Black
24 | Black
25 | Green
 | 2009-04-30 00:00:00
 | 2009-01-31 00:00:00
 | 2009-02-28 00:00:00
 | 2009-03-31 00:00:00
 | 2009-04-30 00:00:00
 | 2009-05-31 00:00:00
 | 2009-06-30 00:00:00
 | 2009-07-31 00:00:00
 | 2009-08-31 00:00:00
 | 2009-09-30 00:00:00
 | 2009-10-31 00:00:00
 | 2009-11-30 00:00:00
 | 2009-12-31 00:00:00