Hi everyone,
I'm working on an Excel sheet, but I can't seem to come up with a formula that will work with my data. What I must do is as follows:
I have two columns: one with product names and one with sales numbers. A third column that determines the proportion of each product's sales to the sum of all product sales is what I want to add.
For instance, the formula should display 10%, 20%, and 30% for each product in the third column if I have three products with sales numbers of $100, $200, and $300, respectively.
Could someone kindly assist me with this formula? Despite my efforts, I haven't had the desired outcomes.
Thank you in advance for your help!
I'm working on an Excel sheet, but I can't seem to come up with a formula that will work with my data. What I must do is as follows:
I have two columns: one with product names and one with sales numbers. A third column that determines the proportion of each product's sales to the sum of all product sales is what I want to add.
For instance, the formula should display 10%, 20%, and 30% for each product in the third column if I have three products with sales numbers of $100, $200, and $300, respectively.
Could someone kindly assist me with this formula? Despite my efforts, I haven't had the desired outcomes.
Thank you in advance for your help!