Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Get "Large" from list
Hello All:
I asked already this question in not a clear manner, so I got unclear answers. So I would like to ask again my question. I hope someone will understand it and help me. My goal is to get results from three variables. I have the following chart: Type Company 1 Company 2 Company 3 Product Plastic 3.69 0.79 0.89 Metal 0.99 2.57 1.99 Wood 1.69 0.89 0.99 Then I have this chart: Code Amount Item Amount Item Amount Item 111 2 Plastic 3 Wood 5 Metal 222 3 Wood 1 Plastic 333 1 Wood 4 Metal 3 Plastic I would like in the next cell for code 111 should tell me the amount of "Large(1)" for All the items on that row (111) Then the next cell "Large(2)" for the same code (111). and so on. So for example, the first cell should state: $17.40 (which is a total of 7.38+5.07+4.95) The next cell should state: $17.10 (which is a total of 1.58+2.67+12.85). I hope you understand my question. Please help me, these calculations is driving me nuts. And I don't know any easier way to do this. If I can do this calculation with VBA then I'll use that instead. Thanks for any help. Art. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Get "Large" from list
O2
I put the 1st table in cells A1:D4 anf the 2nd table H1:N4. =($I2*SUMPRODUCT(--($J2=$A2:$A4),D2:D4))+($K2*SUMPRODUCT(--($L2=$A2:$A4),D2:D4))+($M2*SUMPRODUCT(--($N2=$A2:$A4),D2:D4)) I copied O4 to O4:Q6 I then put the folloing formula in "art" wrote: Hello All: I asked already this question in not a clear manner, so I got unclear answers. So I would like to ask again my question. I hope someone will understand it and help me. My goal is to get results from three variables. I have the following chart: Type Company 1 Company 2 Company 3 Product Plastic 3.69 0.79 0.89 Metal 0.99 2.57 1.99 Wood 1.69 0.89 0.99 Then I have this chart: Code Amount Item Amount Item Amount Item 111 2 Plastic 3 Wood 5 Metal 222 3 Wood 1 Plastic 333 1 Wood 4 Metal 3 Plastic I would like in the next cell for code 111 should tell me the amount of "Large(1)" for All the items on that row (111) Then the next cell "Large(2)" for the same code (111). and so on. So for example, the first cell should state: $17.40 (which is a total of 7.38+5.07+4.95) The next cell should state: $17.10 (which is a total of 1.58+2.67+12.85). I hope you understand my question. Please help me, these calculations is driving me nuts. And I don't know any easier way to do this. If I can do this calculation with VBA then I'll use that instead. Thanks for any help. Art. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
cannot use "Create List" and "Share Workbook" same time | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Utility to "clean up" or "defrag" large Excel file | Excel Discussion (Misc queries) |