Look-up question.

[s.ro10]

I have a table similar to this(if it doesnt show up right, hope you get the idea):
. Day 1 [] Day 2
Name |Work Order|Hours|Work Order|Hours|Total| "."
A 11-101 5 11-102 3 8 [] "."
B .... .. ..... . . [] ...

Basically a timesheet for the work week with work order #s and hour totals broken up per day vertically and per employee horizontally.

I'm trying to write a formula that looks up a certain WO(11-999) and adds all the hours a given employee(A) has worked on that certain WO throughout the week.

Some help would be greatly appreciated as I'm having some trouble with this.

Thanks.

 

[s.ro10]

bump.

 

[jasonb75]

Based on your source data being in sheet1, with the same 14 column layout for each day, including sat & sun.

Excel Workbook
	A	B
1		11-999
2	A	0
3	B
4	C
Sheet2

 

[s.ro10]

Cheers.

Much appreciated.