Spreadsheet: 113141d1309117334-6-month-range-formula-help-6-month-interval-sample
Sheet: Sheet3

Date | Competency | Amount | Year | Month | Helper
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME] |  |  |  |  |  |  | Sum of Amount | Column Labels
 | [NAME] |  |  |  |  |  |  | Row Labels | 6 - 12 2009 | 1 -6 2010 | 6 - 12 2010 | 1 -6 2011 | Grand Total
 | Fred |  |  |  |  |  |  | [NAME] | 453 | 493 | 400 | 305 | 1651
 | [NAME] |  |  |  |  |  |  | [NAME] | 372 | 445 | 320 | 525 | 1662
 | [NAME] |  |  |  |  |  |  | Fred | 458 | 311 | 320 | 481 | 1570
 | Marv |  |  |  |  |  |  | [NAME] | 322 | 494 | 335 | 409 | 1560
 | Tyler |  |  |  |  |  |  | Marv | 404 | 392 | 456 | 432 | 1684
 | [NAME] |  |  |  |  |  |  | [NAME] | 454 | 318 | 430 | 451 | 1653
 | [NAME] |  |  |  |  |  |  | Tyler | 501 | 434 | 381 | 375 | 1691
 | Fred |  |  |  |  |  |  | Grand Total | 2964 | 2887 | 2642 | 2978 | 11471
 | [NAME]
 | [NAME]
 | Marv
 | Tyler |  |  |  |  |  |  | I built a Helper Column for the Column heads above to show months and years
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv
 | Tyler