Angel.pie001
New Member
- Joined
- Jun 25, 2012
- Messages
- 14
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
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