Excel index/match

[Angel.pie001]

A-----B
r1----15
r2----17
r5----19
r1----15

i tried match/index INDEX(D:D,MATCH("r1",E:E,0))

but it only gives me the result as "15" i.e first r1 value

i want the sum of all r1 values in that row

answer should be=30

thanks
help

 

[Robert Mika]

Excel Workbook
	B	C	D	E
1	r1		r1	15
2	30		r2	17
3			r5	19
4			r1	15
Sheet1

 

[VoG]

Try

=SUMIF(A:A,"r1",B:B)

 

[Charlie45]

Try =SUMPRODUCT( --(D:D="r1"),--(E:E))