Match to get the totals

[KingTamo]

In column A I have the numbers:
10
20
30
40
50
and in column B I have some values for each number:
0.5
0.25
0.3
0.75
1.25

In column D I have a list:
10
10-20
10-20-30
20-30
30
40
40-50

I need in column E to get the sum totals for each number by the value next to it in column B. so column E should
0.5
0.75
1.05
0.55
30
0.75
2

[nankw83]

Hi KingTamo,

Try below code ...

Please Login or Register  to view this content.

[Vraag en antwoord]

or

Please Login or Register  to view this content.

[KingTamo]

Both your solutions working well. Thank you so much.

[nankw83]

Glad to help & thanks for the Rep+

PS: This is a more simplified version as well ...

Please Login or Register  to view this content.