On 2/27/2010 2:06 AM, Are wrote:
Dear Masters,

Please help me how to get this result
D E
2 110 -
3 110 102
4 80 -
5 66 -
6 82 75
7 70 -

result : 1.84 =(E3/D3)+(E6/D6)
but I mean not manually, maybe any Masters can help me..

Thanks in advance..

One way if I assume you are using the entire table.

=SUMPRODUCT(E2:E7,1/(D2:D7))

Returns:
1.84

= = = = = = =
HTH :)
Dana DeLouis