addition with conditions without using macro.values are dynamic.

[jatink]

A B C D E F G

1 a	200	a:10	b:20	c:30	d:40
2 b	500	a:10	b:20	c:30	d:40
3 c	1000	a:10	b:20	c:30	d:40
4 d	100	a:10	b:20	c:30	d:40

<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>

in G1 cell i want to multiply 200 with a's value i.e. 10(a;10) of C
in G2 cell i want to multiply 500 with b'value i.e. 20(b:20) of D
in G3 cell i want to multiply 1000 with c'value i.e. 30(c:30) of E
in G4 cell i want to multiply 100 with d'value i.e. 40(d:40) of F

values are dynamic not static.
without using macro what is the expression.plz help..!!

 

[Peter_SSs]

Welcome to the MrExcel board!

It is quite hard to tell what is in what columns of your sample data.
Also, your title says Addition but your description is about Multiplication.

Is this what you want? If not, more details please.
You might also note my signature block below for ways to post (small) clear screen shots like this.

Formula in G1 copied down.

Excel Workbook
	A	B	C	D	E	F	G
1	a	200	a:10	b:20	c:30	d:40	2000
2	b	500	a:10	b:20	c:30	d:40	10000
3	c	1000	a:10	b:20	c:30	d:40	30000
4	d	100	a:10	b:20	c:30	d:40	4000
jatink

 

[jatink]

thanks alot....

 

[Peter_SSs]

thanks alot....

No problem. Glad it helped.