sum and devide with not null value

  • Thread starter Thread starter Are
  • Start date Start date
A

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..
 
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
 
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..
Click to expand...

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

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

Returns:
1.84

= = = = = = =
HTH :>)
Dana DeLouis
 
Back
Top