Sum multiple criteria in rows and across columns

[mnedbal]

I am looking to use either a formula or VBA script to sum values based on employee name, project and date range. The original table is below. I modified the original to copy the employee name in each row in order to do SUM (shown in light grey in the table). What I am after is summing a total value based on employee name, project name, and date range. The problem I am having is summing a horizontal date range. For example, I want the total number of hours for employee 1 who worked on project 2 between the months of Feb and Mar (8). I know how to use simple SUMIF array formulas but how can I capture the date range across columns?
Thanks,
Mike

		Jan 14	Feb 14	Mar 14
Employee 1
Employee 1	Project1	0	5	0
Employee 1	Project2	1	2	6
Employee 1	Project3	0	0	0
Total Employee 1		1	7	6
Employee 2
Employee 2	Project1	1	5	4
Employee 2	Project2	0	2	2
Employee 2	Project3	3	1	0
Total Employee 2		4	8	6

<tbody>
</tbody>

 

[mnedbal]

With the help of Tony Valko, I found a solution:
=SUMPRODUCT((A2:A10=G2)*(B2:B10=H2)*(C1:E1>=I2)*(C1:E1<=J2)*C2:E10) where G2 is employee name, H2 is project name, I2 is start date, J2 is end date.

I am looking to use either a formula or VBA script to sum values based on employee name, project and date range. The original table is below. I modified the original to copy the employee name in each row in order to do SUM (shown in light grey in the table). What I am after is summing a total value based on employee name, project name, and date range. The problem I am having is summing a horizontal date range. For example, I want the total number of hours for employee 1 who worked on project 2 between the months of Feb and Mar (8). I know how to use simple SUMIF array formulas but how can I capture the date range across columns?
Thanks,
Mike

		Jan 14	Feb 14	Mar 14
Employee 1
Employee 1	Project1	0	5	0
Employee 1	Project2	1	2	6
Employee 1	Project3	0	0	0
Total Employee 1		1	7	6
Employee 2
Employee 2	Project1	1	5	4
Employee 2	Project2	0	2	2
Employee 2	Project3	3	1	0
Total Employee 2		4	8	6

<tbody>
</tbody>