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. |
Get "Large" from List
Hi Art
Looking at your example, I can not figure out, what you want to do. Can you describe in words which result you require, and how to calculate the result 17.04 and its sub results. Regards, Per "art" skrev i meddelelsen ... 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. |
All times are GMT +1. The time now is 03:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com