Index match multiple criteria in rows and columns

[XL_CLUELESS]

I am hoping to return the number of hours that matches 3 criteria. For example For project 100 where R1 is the Project Manager I would like to return how many hours each resource did in part 1 of the project in one column and return the value of the amount of hours she did for Part 2.

A	B	C	D		E		F		G		H		I		J
1	Project	PM	Resource1		Resource2		Resource3		Resource4		Resource5		Resource6		Resource7
			Part1	Part2	Part1	Part2	Part1	Part2	Part1	Part2	Part1	Part2	Part1	Part2	Part1	Part2
2	100	R1	15		2		6	5
3	200	R2		10		1				3
4	300	R3		2	1		2					7			8
5	400	R1	22		2
6	500	R3					3	12		5	17		8	1		1
7	600	R4			8						5		6		7
8	700	R1				1		2								8
9	800	R4	5	16
10	900	R2				22	1		5	12
11	110	R3									8		2	8		1

<tbody>
</tbody>

Hope this makes sense. All help is appreciated. I tried using Index Match functions but I keep getting a N/A value.

 

[DRSteele]

Welcome to the forum.

It's unclear what you are after. Are you asking to sum up the number of hours for each PM in each of the Resources in which he participated and for each part in which he participated?

Could you please include a table of desired results?

 

[XL_CLUELESS]

Thanks for your reply. For example, from the original table above (which other project managers are going to be filling in for their resources) I need to look up what hours each resource is working on for part 1 and part 2 of the project. Its hard to explain I hope this makes more sense?

Project	Resource	Part 1	Part 2
100	Resource 1	=hours completed by "Resource1" for Project "100" for "Part 1"	=hours completed by "Resource1" for Project "100" for "Part 2"
100	Resource 2	=hours completed by "Resource2" for Project "100" for "Part 1"	=hours completed by "Resource2" for Project "100" for "Part 2"
100	Resource 3	=hours completed by "Resource3" for Project "100" for "Part 1"	=hours completed by "Resource3" for Project "100" for "Part 2"
200	Resource 2	=hours completed by "Resource2" for Project "200" for "Part 1"	=hours completed by "Resource2" for Project "200" for "Part 2"
200	Resource 4	=hours completed by "Resource4" for Project "200" for "Part 1"	=hours completed by "Resource4" for Project "200" for "Part 2"
400	Resource 3	=hours completed by "Resource3" for Project "400" for "Part 1"	=hours completed by "Resource3" for Project "400" for "Part 2"
400	Resource 2	=hours completed by "Resource2" for Project "400" for "Part 1"	=hours completed by "Resource2" for Project "400" for "Part 2"
400	Resource 4	=hours completed by "Resource4" for Project "400" for "Part 1"	=hours completed by "Resource4" for Project "400" for "Part 2"
400	Resource 1	=hours completed by "Resource1" for Project "400" for "Part 1"	=hours completed by "Resource1" for Project "400" for "Part 1"

<tbody>
</tbody>