Hello, I was hoping to get some help on a formula on the below data spreadsheet snapshot. I was looking for a way to pull totals by job title for the date entered. I have another sheet set up where the user can change the date and would like the info to update. Ex. if the user changes the date to 1/2/14 the Supervisor line would read 62 (adding all supervisors for that day 9+5+37+11)
<colgroup><col><col><col span="4"></colgroup><tbody>
</tbody>
Dept | Job Title | 1/1/2014 | 1/2/2014 | 1/3/2014 | 1/4/2014 |
100 | SPECIALIST | 140 | 89 | 204 | 138 |
100 | SUPERVISOR | 5 | 9 | 9 | 16 |
100 | SUPERVISOR | 0 | 5 | 6 | 6 |
100 | SUPERVISOR | 39 | 37 | 40 | 40 |
100 | SUPERVISOR | 11 | 11 | 6 | 11 |
100 | TECHNICIAN | 94 | 42 | 64 | 49 |
100 | TECHNICIAN | 38 | 70 | 70 | 42 |
100 | TECHNICIAN | 18 | 8 | 8 | 8 |
<colgroup><col><col><col span="4"></colgroup><tbody>
</tbody>