sum/sumiif on transposed range

[Gabie1411]

I have a set of data in rows but on the next sheet i need to sum the info depending on the options i have chosen what formula should be used?

example below
Sheet 1

Option price
A 5
B 10
C 20
D 17
E 30

Sheet 2

Option option

A D


i need a formula to show it would be 22 (i.e 5+17)

Thanks

 

[sheetspread]

Excel 2010
	A	B
1	Option	Price
2	A	5
3	B	10
4	C	20
5	D	17
6	E	30
7
8
9
10	Option	Option2
11	A	D
12
13	22
Sheet4

Cell Formulas
Range	Formula
A13	=SUMPRODUCT(SUMIF($A$2:$A$6,$A$11:$B$11,$B$2:$B$6))