Excel

[alliswell]

Hi everybody
A B C D E
1 Product Total 50 5
2 2,3 115

A2 has 2,3 and B2 has total 115
I want is that 2,3 in A2 must get multiplied by D1 n E1 such way that 2 must get multiplied by D1
And 3 must get multiplied by E1 and sum results in B2.

 

[AhoyNC]

Maybe:

Book1
	A	B	C	D	E
1				50	5
2	2,3	115
Sheet2

Cell Formulas
Range	Formula
B2	B2	=LEFT(A2,SEARCH(",",A2)-1)*D1+MID(A2,(SEARCH(",",A2)+1),LEN(A2))*E1

 

[alliswell]

Dear AhoyNc
Suppose if i have 2,3,7,4 in A2 and 50,5,10,15 in D1:G1 how will be the formula then in B2 to get the sum.

 

[AhoyNC]

I don't know of an easy way to do this with formulas. Maybe someone can help with a VBA solution.
I would probably use the Text to Columns option under the Data ribbon to separate the numbers into different columns and then the SUMPRODUCT function.