Sum values based on a cell with commas

[haddy]

Hi All,

I've had a browse and i can't seem to find this example. I've found examples of codes summing the numbers within the cell but nothing that i can find relating to finding the numbers within the cell seperated by either commas, slashes, etc - linking them back to a table or a list and summing numbers attached.

Basically;
Find all numbers in D2 (A1, A4, A5)
Sum relevant numbers in E2 (B2, B4, B5)

A	B	C	D	E
1	100			Total
2	30		2,4,5
3	20
4	15
5	25

<tbody>
</tbody>

Unfortunately i've got a very limited VBA understanding, and i hope I've made it easy to understand where I'm getting at

Haddy

 

[haddy]

Remark: the sum of values in B2, B4 and B5 is 70, not 60.

Ops


now to understand how it is done..thank you all

 

[Aladin Akyurek]

Ops


now to understand how it is done..thank you all

Which formula do you consider or are you using?

 

[haddy]

---

Which formula do you consider or are you using?

I'd have to say the one you have posted, as the intended data isn't much more complex than the example data.
Though understanding each options is beneficial

___

in case you were referring to 'now to understand how it's done' - i can do that in my own time, thanks Aladin