Need to Multiply with 2 criteria

[asksign]

Hi,

I need to multiply A1 x A2, B1 x B2, C1 x C2 & D1 x D2 and so on, but the answer should come as shown below.

					Expected Answer
	A	B	C	D	Total Weight in gms
1	1gm	2gm	3gm	4gm
2	1	2	2	3	23
3	2	5		1	16
4	2		2	5	28

<colgroup><col span="5"><col></colgroup><tbody>
</tbody>

Can anyone help me in this.

 

[Michael M]

Try

=LEFT(A1,1)*A2+LEFT(B1,1)*B2+LEFT(C1,1)*C2+LEFT(D1,1)*D2

but it would be much easier to remove the gms from the cells and insert e nemw title row called gms !!

 

[Peter_SSs]

I agree with Michael that it would be simpler if you could remove the "gm" from the top row. Then you could use this, copied down.

Excel Workbook
	A	B	C	D	E
1	1	2	3	4
2	1	2	2	3	23
3	2	5		1	16
4	2		2	5	28
Multiply 1

However, even with the "gm" text in that top row, try this, copied down.

Excel Workbook
	A	B	C	D	E
1	1gm	2gm	3gm	4gm
2	1	2	2	3	23
3	2	5		1	16
4	2		2	5	28
Multiply 2

BTW Michael, yours would fail if something like 12gm was possible in the top row. It also needs some $ signs if it is to be copied to the other rows.

 

[Michael M]

Thanks Peter, was aware of the 12gm...