sum and devide with not null value

[Are]

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

 

[Fred Smith]

You need to describe your problem more clearly. e3/d3+e6/d6 does not result
in 1.84. What specifically are you looking for?

Regards,
Fed

 

[Dana DeLouis]

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/(D27))

Returns:
1.84

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