How to Calculate Contribution Percentage with Formula in Excel

Get FREE Advanced Excel Exercises with Solutions!

We have values from different sources listed for certain periods. This listing indicates the contributions of each period of items over the period of time. It is always better to have those contributions presented in percentage format in contrast to plain data values. If you are curious to know how you can calculate the contribution percentages with a formula, this article may come in handy for you. In this article, we are going to demonstrate how you can calculate the contribution percentage with a formula in Excel with an elaborate explanation.


Download Practice Workbook

Download this practice workbook below.


What Is Contribution Percentage?

The Contribution Percentage is the proportion of the user’s contribution percentage amount to their compensation for the plan year, expressed as a percentage. Normally, the contribution is viewed as the value of each henry. But the overview of the whole process would be simpler if we present the value of each cell with respect to its percentage of the total. This increases clarity a lot more.


3 Suitable Examples to Estimate Contribution Percentage with Formula in Excel

Below, we have presented three separate examples to illustrate how you can estimate the contribution percentage with various formulas. For avoiding any kind of compatibility issues, use Excel 365 edition.

1. Calculate Contribution Percentage Based on Age Bands

In the dataset below, we will demonstrate how you can get the percentage contribution from each age range adult. We will use the SUM function for this purpose.

Steps

  • In the dataset below, we got the people’s age band and their frequency.

Calculate Contribution Percentage Based on Age Bands

  • Then we need to evaluate the summation of the frequencies.
  • To do this, select the cell C12 and enter the following formula in the cell:

=SUM(C5:C11)

  • Then we need to calculate the percentages of each people of each range.
  • To do this, select the cell D5 and enter the following formula:

=C5/$C$12

  • And then drag the Fill Handle to cell D11.

  • But the values are in number format and we want to convert them to Percentage.

  • To do this, select the range of cells D5:D11 and then go to the Home tab > Number format.
  • Then from the drop-down box, click on the Percentage.
  • After selecting Percentage, the range of cells D5:D11 is something below.

Output of contribution percentage values in percentage format

Read More: How to Apply Percentage Formula for Multiple Cells in Excel (5 Methods)


2. Calculate Top 25% Contribution Percentage in Excel

In the dataset presented below, we have the product Id and their amount of contribution in the total sale. For the sake of better clarity, it’s better to present them in percentage-wise contribution compared to value-based contribution. In the below dataset, we will evaluate each of their contributions on a percentage basis, using the IF, PERCENTILE.INC and SUM function.

Steps

  • We need to calculate the input data in the top 25 percent contributor of the total range.
  • For this, select cell C19 and enter the following formula:

=SUM(C11:C18)

Calculate Top 25% Contribution Percentage in Excel

  • Then to determine whether the sales values are in the top 25% or not, we enter the below formula in the cell D4:

=IF(C5>=PERCENTILE.INC($C$5:$C$18,0.75),"In top 25%","")

  • Then drag the Fill Handle to cell D18.

Comment on whether the value is in the top 25% or not.

Read More: How to Calculate Percentage for Multiple Rows in Excel


Similar Readings


3. Calculate Monthly Contribution Percentage Based on Sales Data

Based on the monthly sales value we can calculate the contribution of the month to the total sales throughout the year. We are going to use the SUM function in order to get the contribution percentage

Steps

  • To calculate the sales percentage of the total sales value
  • We need to calculate the total sales value first, for this, enter the following formula in the cell C17:

=SUM(C5:C16)

Calculate Monthly Contribution Percentage Based on Sales Data

  • Then select cell D5 and then enter the following formula:

=C5/$C$17

  • Then drag the Fill Handle to cell D16.

  • But the values are in number format and we want to convert them to Percentage format.
  • To do this, select the range of cells D5:D11 and then go to the Home tab > Number format.
  • Then from the drop-down box, click on the Percentage.

  • After selecting Percentage, the range of cells D5:D11 is something below.

output sales monthly contribution percentage based in percentage format

Read More: How to Calculate Percentage of Sales in Excel (4 Examples)


How to Calculate Sales Contribution Percentage in Excel

In the below dataset, we have the dataset of the sales value of each region. The contribution here is actually presented with respect to the value amount. But for better clarity, it’s better to present them in percentage format instead of value format. We are going to use the SUM function in order to get the contribution percentage.

Steps

  • We need to get the sales contributions of each region.
  • For this, we need to get the total sales value of all the regions mentioned here.
  • To do this, select cell C12 and enter the following formula:

=SUM(C5:C11)

Entering this formula will calculate the summation of region amount sales in the range of cells C5:C11.

Calculate Sales Contribution Percentage in Excel

  • Now, we select cell D5 and enter the formula below:

=C5/$C$12

  • Then drag the Fill Handle to cell D11.

  • Doing this will fill the range of cell D5:D11 with the percentage contribution of each region.
  • But the values are in number format and we want to convert them to Percentage format.
  • To do this, select the range of cells D5:D11 and then go to the Home tab > Number format.
  • Then from the drop-down box, click on the Percentage.

  • After selecting Percentage, the range of cells D5:D11 is something below.

Output of Calculating sales contribution percentages in Excel

Read More: How to Calculate Sales Growth Percentage in Excel (3 Easy Approaches)


💬 Things to Remember

Always remember to switch the format of the cell values. The format can be in number format, so the value can seem bizarre. Switching to the percentage with two decimal places will be better.


Conclusion

To sum it up, the issue of how we can calculate the contribution percentage with a formula in Excel with 3 examples.

A workbook is available to download where you can practice these methods.

Feel free to ask any questions or provide feedback through the comment section. Any suggestion for the betterment of the Exceldemy community will be highly appreciable


Related Articles

Rubayed Razib Suprov
Rubayed Razib Suprov

Hi, I am Rubayed Razib Suprov. Graduated from the Bangladesh University of Engineering Technology in Naval Architecture and Marine Engineering department. I joined Exceldemy on March 2022. I have a keen interest in both fluid dynamics and data analysis. I try to teach people what I learned so far about the Excel tool to date, and hope I can make some positive impacts.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo