Spreadsheet: 216577d1361815122-sum-of-multiple-cells-based-on-two-headers-example
Sheet: Sheet1

 |  |  |  |  | 2012-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-01-07 00:00:00 | 2013-01-07 00:00:00 | 2013-01-14 00:00:00 | 2013-01-14 00:00:00 | 2013-01-21 00:00:00 | 2013-01-21 00:00:00 | 2013-01-28 00:00:00 | 2013-01-28 00:00:00 | 2013-02-04 00:00:00 | 2013-02-04 00:00:00 | 2013-02-11 00:00:00 | 2013-02-11 00:00:00 | 2013-02-18 00:00:00 | 2013-02-18 00:00:00 | 2013-02-25 00:00:00 | 2013-02-25 00:00:00 | 2013-03-04 00:00:00 | 2013-03-04 00:00:00 | 2013-03-11 00:00:00 | 2013-03-11 00:00:00 | 2013-03-18 00:00:00 | 2013-03-18 00:00:00 | 2013-03-25 00:00:00 | 2013-03-25 00:00:00
 |  | ANNUAL BUDGETED NONBILLABLE TIME | MONTHLY BUDGETED NONBILLABLE TIME | WEEKLY BUDGETED NONBILLABLE TIME | BUDGETED | ACTUAL | BUDGETED | ACTUAL | BUDGETED | ACTUAL | BUDGETED | ACTUAL | BUDGETED | ACTUAL | BUDGETED | ACTUAL | BUDGETED | ACTUAL | BUDGETED | ACTUAL | BUDGETED | ACTUAL | BUDGETED | ACTUAL | BUDGETED | ACTUAL | BUDGETED | ACTUAL | BUDGETED | ACTUAL | TOTAL BUDGETED YEAR TO DATE | TOTAL ACTUAL YEAR TO DATE | TOTAL BUDGETED MONTH TO DATE | TOTAL ACTUAL MONTH TO DATE | TOTAL BUDGETED LAST WEEK | TOTAL ACTUAL LAST WEEK | TOTAL BUDGETED THIS WEEK | TOTAL ACTUAL THIS WEEK
 | 1 | 40 |  |  | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0
 | 2 | 40 |  |  | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0
 | 3 | 40 |  |  | 0.7692307692307693 | 2 | 0.7692307692307693 | 2 | 0.7692307692307693 | 2 | 0.7692307692307693 | 2 | 0.7692307692307693 | 2 | 0.7692307692307693 | 2 | 0.7692307692307693 | 2 | 0.7692307692307693 | 2 | 0.7692307692307693 | 2 | 0.7692307692307693 | 2 | 0.7692307692307693 | 2 | 0.7692307692307693 | 2 | 0.7692307692307693 | 2
 | 5 | 40 |  |  | 0.7692307692307693 | 3 | 0.7692307692307693 | 3 | 0.7692307692307693 | 3 | 0.7692307692307693 | 3 | 0.7692307692307693 | 3 | 0.7692307692307693 | 3 | 0.7692307692307693 | 3 | 0.7692307692307693 | 3 | 0.7692307692307693 | 3 | 0.7692307692307693 | 3 | 0.7692307692307693 | 3 | 0.7692307692307693 | 3 | 0.7692307692307693 | 3
 | 5 | 40 |  |  | 0.7692307692307693 | 3 | 0.7692307692307693 | 3 | 0.7692307692307693 | 3 | 0.7692307692307693 | 3 | 0.7692307692307693 | 3 | 0.7692307692307693 | 3 | 0.7692307692307693 | 3 | 0.7692307692307693 | 3 | 0.7692307692307693 | 3 | 0.7692307692307693 | 3 | 0.7692307692307693 | 3 | 0.7692307692307693 | 3 | 0.7692307692307693 | 3
 | 6 | 40 |  |  | 0.7692307692307693 | 2.25 | 0.7692307692307693 | 2.25 | 0.7692307692307693 | 2.25 | 0.7692307692307693 | 2.25 | 0.7692307692307693 | 2.25 | 0.7692307692307693 | 2.25 | 0.7692307692307693 | 2.25 | 0.7692307692307693 | 2.25 | 0.7692307692307693 | 2.25 | 0.7692307692307693 | 2.25 | 0.7692307692307693 | 2.25 | 0.7692307692307693 | 2.25 | 0.7692307692307693 | 2.25
 | 7 | 40 |  |  | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0
 | 8 | 40 |  |  | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0
 | 9 | 40 |  |  | 0.7692307692307693 | 8 | 0.7692307692307693 | 8 | 0.7692307692307693 | 8 | 0.7692307692307693 | 8 | 0.7692307692307693 | 8 | 0.7692307692307693 | 8 | 0.7692307692307693 | 8 | 0.7692307692307693 | 8 | 0.7692307692307693 | 8 | 0.7692307692307693 | 8 | 0.7692307692307693 | 8 | 0.7692307692307693 | 8 | 0.7692307692307693 | 8
 | COTA TOTAL USED | 360 |  |  | 6.923076923076923 | 18.25 | 6.923076923076923 | 18.25 | 6.923076923076923 | 18.25 | 6.923076923076923 | 18.25 | 6.923076923076923 | 18.25 | 6.923076923076923 | 18.25 | 6.923076923076923 | 18.25 | 6.923076923076923 | 18.25 | 6.923076923076923 | 18.25 | 6.923076923076923 | 18.25 | 6.923076923076923 | 18.25 | 6.923076923076923 | 18.25 | 6.923076923076923 | 18.25
 | 10 | 40 |  |  | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0
 | 11 | 40 |  |  | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0
 | 12 | 40 |  |  | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0
 | 13 | 40 |  |  | 0.7692307692307693 | 8 | 0.7692307692307693 | 8 | 0.7692307692307693 | 8 | 0.7692307692307693 | 8 | 0.7692307692307693 | 8 | 0.7692307692307693 | 8 | 0.7692307692307693 | 8 | 0.7692307692307693 | 8 | 0.7692307692307693 | 8 | 0.7692307692307693 | 8 | 0.7692307692307693 | 8 | 0.7692307692307693 | 8 | 0.7692307692307693 | 8
 | 14 | 40 |  |  | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0
 | 15 | 40 |  |  | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0
 | 16 | 40 |  |  | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0
 | 17 | 40 |  |  | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0
 | 18 | 40 |  |  | 0.7692307692307693 | 10 | 0.7692307692307693 | 10 | 0.7692307692307693 | 10 | 0.7692307692307693 | 10 | 0.7692307692307693 | 10 | 0.7692307692307693 | 10 | 0.7692307692307693 | 10 | 0.7692307692307693 | 10 | 0.7692307692307693 | 10 | 0.7692307692307693 | 10 | 0.7692307692307693 | 10 | 0.7692307692307693 | 10 | 0.7692307692307693 | 10
 | 19 | 40 |  |  | 0.7692307692307693 | 4 | 0.7692307692307693 | 4 | 0.7692307692307693 | 4 | 0.7692307692307693 | 4 | 0.7692307692307693 | 4 | 0.7692307692307693 | 4 | 0.7692307692307693 | 4 | 0.7692307692307693 | 4 | 0.7692307692307693 | 4 | 0.7692307692307693 | 4 | 0.7692307692307693 | 4 | 0.7692307692307693 | 4 | 0.7692307692307693 | 4
 | 20 | 40 |  |  | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0 | 0.7692307692307693 | 0
 | 21 | 40 |  |  | 0.7692307692307693 | 2 | 0.7692307692307693 | 2 | 0.7692307692307693 | 2 | 0.7692307692307693 | 2 | 0.7692307692307693 | 2 | 0.7692307692307693 | 2 | 0.7692307692307693 | 2 | 0.7692307692307693 | 2 | 0.7692307692307693 | 2 | 0.7692307692307693 | 2 | 0.7692307692307693 | 2 | 0.7692307692307693 | 2 | 0.7692307692307693 | 2
 | 22 | 40 |  |  | 0.7692307692307693 | 1 | 0.7692307692307693 | 1 | 0.7692307692307693 | 1 | 0.7692307692307693 | 1 | 0.7692307692307693 | 1 | 0.7692307692307693 | 1 | 0.7692307692307693 | 1 | 0.7692307692307693 | 1 | 0.7692307692307693 | 1 | 0.7692307692307693 | 1 | 0.7692307692307693 | 1 | 0.7692307692307693 | 1 | 0.7692307692307693 | 1
 | OTR TOTAL | 400 |  |  | 6.923076923076923 | 17 | 6.923076923076923 | 17 | 6.923076923076923 | 17 | 6.923076923076923 | 17 | 6.923076923076923 | 17 | 6.923076923076923 | 17 | 6.923076923076923 | 17 | 6.923076923076923 | 17 | 6.923076923076923 | 17 | 6.923076923076923 | 17 | 6.923076923076923 | 17 | 6.923076923076923 | 17 | 6.923076923076923 | 17