Reviewing different worksheets summing numbers in one column based on matches in two other columns

[vdurrington]

I need to be able to match values in a worksheet to determine a cell value in another worksheet. Here’s an example of what I’m trying to do. Based on the cells below, I first need to determine if the value in A2:A5 is "EDN". For the row that has the value "EDN", I need to determine if the value in column B of the same row is either "200", "203", "301", or "303". For each instance where the value in column A & B of the same row match the criteria, then I want add the corresponding values in column C.

Excel Workbook
	B	C	J
6	Course	Course
7	Prefix	Number	FTE
8	EDN	528	0.14
9	SEC	200	0.20
10	SEC	500	0.14
11	SEC	528	0.28
Smith

Excel 2007

Cell Formulas
Range	Formula
J8	=IF(ISBLANK(E8)," ",((E8*F8)/(INDEX(Table!$G$9:$I$12,H8,I8)))*(G8/100))
J9	=IF(ISBLANK(E9)," ",((E9*F9)/(INDEX(Table!$G$9:$I$12,H9,I9)))*(G9/100))
J10	=IF(ISBLANK(E10)," ",((E10*F10)/(INDEX(Table!$G$9:$I$12,H10,I10)))*(G10/100))
J11	=IF(ISBLANK(E11)," ",((E11*F11)/(INDEX(Table!$G$9:$I$12,H11,I11)))*(G11/100))

If I was looking for values of EDN and 200, then the resulting sum = 0.0

If I is was looking for SEC and 200, then the resulting sum = .20

If I was looking for SEC and 500 or 528, then the resulting sum = .42

If I was looking for EDN or SEC and 528, then the resulting sum = .42

If I was looking for EDN or SEC and 500 or 528, then the resulting sum = .56

I'm hoping this makes sense.

Thanks!