splitting 2 cell values by comma, then sumproduct

[antenkt]

Need help.....

I have 2 different cells having values separated by "comma" (,). result should appear in third cell as sumproduct of these two input cells.

e.g:-

5,10 200,100 2000 (=+5*200+10*100)

1,2,3 50,100,150 700 (=+1*50+2*100+3*150)

thanking you in advance,

 

[Peter_SSs]

Welcome to the MrExcel board!

This should work for up to 5 numbers per cell. It can be scaled it up if needed.

Excel Workbook
	A	B	C
1	5,10	200,100	2000
2	1,2,3	50,100,150	700
Sumproduct

 

[antenkt]

I really appreciate for your hard work. thank you.

 

[Peter_SSs]

I really appreciate for your hard work. thank you.

You're welcome.