sum and devide with not null value
 

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

sum and devide with not null value
 

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


"Are" wrote in message
...
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..

sum and devide with not null value
 

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