contribution

  1. K

    Excel Product Sales Contribution - what if analysis (Calculate updated contribution based on New sales volume at product level)

    PRODUCT. SALES. CONTRIBUTION A. $250. 25% B $350. 35% C. $100 10% D. $300 30% I am trying to build a simple tool to update contribution % based on user input (new sales volume) for a...
  2. M

    Formula for calculating contribution to change/result

    Hi, I hope I manage to explain this in a way that makes sence. I have two departments which are rated by customers every week. Calculating the change in average score for each department is simple enough, but I need a formula that calculates hos much each department has contributed to the...
  3. A

    Calculate contribution of Salesperson

    Dear, Every month I receive a sales sheet similar to the one attached below. To do a year to date sales sheet I manually copy the new sales sheet and paste it under the old sales sheet. Then I do a pivot table and some interactive charts I learnt recently. The challenge I am facing is...
  4. D

    Loop not working - Run-time Error '1004': Select method of range class failed.

    Hello All. I have an issue in my loop and I have no idea why it's not working. Can anyone please help me. It's the only thing (so far) holding me back from completing this project. In my Payroll project there is a time, every 2 to 3 years, our Government National Insurance Service (a.k.a. NIS)...
  5. K

    Using IF AND statement to return row numbers

    Hi all, I need some help figuring out how to pick up data from one tab within an excel workbook and transposing some of that data onto another tab. Basically, I have a list of names, addresses, and monetary values with a drop down list of answers (yes or no). If the answer is yes I want...
  6. D

    vlookup with multiple criteria

    Driving Table TL_Lookup Empl # Name Trad calc Method Roth calc Method AGE Trad Amt Roth Amt Rate 004 SMITH,JOHN Gross Pay 36 22 25 076 CORTEZ,JANELLE Default 49 140 16.5 137...
  7. H

    How to calculate Contribution using DAX - Complex Business Problem - Please help

    SQL View: a view created from SQL query from different tables Unpivot SQL View: and unpivot version of table created in point 1 through power query Report : Desired presentation Objective: adding contribution column next to sales column where contribution is total sales - total prime cost...
  8. M

    Calculating contribution of Percentages

    I am working with calculations that result in percentages (Rate = Commission / Sales) based on sales and commission for several products. I would like to take the results one step further by determining the contribution that each product makes to the total rate, i.e. I need to be able to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top