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.


[TABLE="width: 504"]
<colgroup><col span="5"><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Expected Answer[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]Total Weight in gms[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1gm[/TD]
[TD]2gm[/TD]
[TD]3gm[/TD]
[TD]4gm[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]16[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]28[/TD]
[/TR]
</tbody>[/TABLE]

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...