How to sum more than one value in from reference cell?

[RookieExcel22]

Suppose I have table 1 that is the below

Number	Value
1234	10
5678	20
9012	35
3456	40

Then I have table two:

Number	SumNumber	Total
A	1234,3456	50
B	5678,9012	55

Is there a formula or macro that I can use in the total column in table two that will sum the values in the value column from table 1 using the values in sumnumber column in table 2?

My only thought is some macro that creates a bunch of columns to then use the text to columns function then sumif against each column, remove formula and then delete the columns. The problem is, the "SumNumber" column is dynamic and may not always be two values. It could be one, it could be 10, etc.

Thank you!

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G
1	Number	Value			Number	SumNumber	Total
2	1234	10			A	1234,3456	50
3	5678	20			B	5678,9012	55
4	9012	35
5	3456	40
6
Sheet6

Cell Formulas
Range	Formula
G2:G3	G2	=SUM(SUMIFS(B:B,A:A,TEXTSPLIT(F2,",")))

 

[RookieExcel22]

How about

Fluff.xlsm
	A	B	C	D	E	F	G
1	Number	Value			Number	SumNumber	Total
2	1234	10			A	1234,3456	50
3	5678	20			B	5678,9012	55
4	9012	35
5	3456	40
6
Sheet6

Cell Formulas
Range	Formula
G2:G3	G2	=SUM(SUMIFS(B:B,A:A,TEXTSPLIT(F2,",")))

Amazing, thank you so much.

 

[Fluff]

You're welcome & thanks for the feedback.