Formula Help

[rehberger]

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)

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>

 

[Weazel]

maybe somthing like...

Where H1 contains the Job title and I1 contains the date


H2=SUMIF($B$2:$B$9,H1,INDEX($C$2:$F$9,,MATCH(I1,$C$1:$F$1,0)))

	A	B	C	D	E	F	G	H	I
1	Dept</SPAN>	Job Title</SPAN>	1/1/2014 </SPAN>	1/2/2014 </SPAN>	1/3/2014 </SPAN>	1/4/2014 </SPAN>		supervisor</SPAN>	1/2/2014 </SPAN>
2	100</SPAN>	SPECIALIST</SPAN>	140</SPAN>	89</SPAN>	204</SPAN>	138</SPAN>		62</SPAN>
3	100</SPAN>	SUPERVISOR</SPAN>	5</SPAN>	9</SPAN>	9</SPAN>	16</SPAN>
4	100</SPAN>	SUPERVISOR</SPAN>	0</SPAN>	5</SPAN>	6</SPAN>	6</SPAN>
5	100</SPAN>	SUPERVISOR</SPAN>	39</SPAN>	37</SPAN>	40</SPAN>	40</SPAN>
6	100</SPAN>	SUPERVISOR</SPAN>	11</SPAN>	11</SPAN>	6</SPAN>	11</SPAN>
7	100</SPAN>	TECHNICIAN</SPAN>	94</SPAN>	42</SPAN>	64</SPAN>	49</SPAN>
8	100</SPAN>	TECHNICIAN</SPAN>	38</SPAN>	70</SPAN>	70</SPAN>	42</SPAN>
9	100</SPAN>	TECHNICIAN</SPAN>	18</SPAN>	8</SPAN>	8</SPAN>	8</SPAN>

<TBODY>
</TBODY>