How to Calculate Contribution Percentage with Formula in Excel

Method 1 – Calculate the Contribution Percentage Based on Age Bands with the SUM Function

In the dataset below, we will demonstrate how you can get the percentage contribution from each age range.

Steps

In the dataset below, we have age bands and their frequency.

Select the cell C12 and enter the following formula in the cell:

=SUM(C5:C11)

Select the cell D5 and enter the following formula:

=C5/$C$12

Drag the Fill Handle to cell D11.

The values are in the number format, and we want to convert them to Percentage.

Select the range of cells D5:D11, go to the Home tab, and then to the Number format.
From the drop-down box, click on the Percentage.
The range of cells D5:D11 is converted.

Method 2 – Calculate Top 25% Contribution Percentage in Excel

We have the product IDs and their sales. Let’s show how much each item has sold for compared to the total and whether the item is in the top 25% of the sellers.

Steps

Select cell C19 and enter the following formula:

=SUM(C11:C18)

To determine whether the sales values are in the top 25%, enter the following formula in cell D4:

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

Drag the Fill Handle to cell D18.

Method 3 – Calculate the 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.

Steps

Enter the following formula in the cell C17:

=SUM(C5:C16)

Select cell D5 and enter the following formula:

=C5/$C$17

Drag the Fill Handle to cell D16.

The values are in the number format and we want to convert them to the Percentage format.
Select the range of cells D5:D11 and then go to the Home tab and the Number format.
From the drop-down, click on Percentage.

The range of cells D5:D11 is converted.

How to Calculate the Sales Contribution Percentage in Excel

Let’s calculate the sales contributions per region compared to the total.

Steps

Select cell C12 and enter the following formula to get the total:

=SUM(C5:C11)

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

Select cell D5 and enter the formula below:

=C5/$C$12

Drag the Fill Handle to cell D11.

Select the range of cells D5:D11 and click on the Percentage icon.

The range of cells D5:D11 is converted.

Things to Remember

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.

Download the Practice Workbook

Contribution Percentage Formula.xlsx