| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charte - how to devide the axes into 2 sones | Charts and Charting in Excel | |||
| devide by 1000 | Excel Discussion (Misc queries) | |||
| Failed to save table attributes of (null) into (null). | Excel Discussion (Misc queries) | |||
| Cell with numbers and names, need to devide them | Excel Discussion (Misc queries) | |||
| devide by 0 error | Excel Worksheet Functions | |||
Linear Mode
