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

Date | Competency | Amount
 | [NAME]
 | Fred
 | [NAME]
 | [NAME]
 | Marv |  |  |  | Sum of Amount | Column Labels
 | Tyler |  |  |  | Row Labels | 7/27/2009 - 1/24/2010 | 1/25/2010 - 7/25/2010 | 7/26/2010 - 1/23/2011 | 1/24/2011 - 6/28/2011 | Grand Total
 | [NAME] |  |  |  | [NAME] | 461 | 355 | 465 | 298 | 1579
 | [NAME] |  |  |  | [NAME] | 503 | 297 | 538 | 310 | 1648
 | Fred |  |  |  | Fred | 515 | 332 | 362 | 351 | 1560
 | [NAME] |  |  |  | [NAME] | 503 | 360 | 397 | 387 | 1647
 | [NAME] |  |  |  | Marv | 516 | 423 | 440 | 287 | 1666
 | Marv |  |  |  | [NAME] | 440 | 421 | 394 | 337 | 1592
 | Tyler |  |  |  | Tyler | 576 | 391 | 314 | 344 | 1625
 | [NAME] |  |  |  | Grand Total | 3514 | 2579 | 2910 | 2314 | 11317
 | [NAME]
 | Fred
 | [NAME]
 | [NAME] |  |  |  | I grouped the PT data above uinsg 182 days
 | Marv
 | Tyler
 | [NAME]
 | [NAME]
 | Fred |  |  | <<Fake Data
 | [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