# How to Calculate Percentage Share in Excel (3 Suitable Ways)

Get FREE Advanced Excel Exercises with Solutions!

Percentage share is a popular term in business organizations. In other sectors, this term is also used. We will calculate the percentage share in Excel based on the formulas in this article.

## Formula for Percentage Share in Excel

Percentage share is the amount of share percentage obtained by each shareholder of a company or organization. Percentage share is important to divide the profit of the organization, as well as the losses.

The formula for percentage share is given below.

## How to Calculate Percentage Share in Excel: 3 Suitable Ways

In this article, we will show 3 methods to calculate percentage share in different conditions in Excel.

### 1. Percentage Share of Two Different Numbers

In this section, we will show the calculation of the percentage share of two numbers of the total in Excel.

We have a dataset of the number of boys and girls in a class. We need to calculate the percentage share of boys and girls in the total.

ðŸ“Œ Steps:

`=SUM(B5:C5)`Â

• Press the EnterÂ button.

• Now, add new rows for calculating the value percentage share.

• Before applying any formula, we change the number format of Range D7:D8. Select the range and press Ctrl +1.

• Choose the Percentage option from the NumberÂ tab.
• Now, input the number of decimal places in the marked box.
• Finally, press OK.

• Now, put this formula on Cell D7.
`=B5/\$D\$5`Â

• Press the EnterÂ button.

We get the percentage share of boys.

• Put the below formula to get the percentage share of girls.
`=C5/\$D\$5`Â

• Again, press the EnterÂ button.

We successfully get the percentage share of boys and girls of the total students.

### 2. Determine the Percentage Share of Y with Respect to X

In this section, we will show the calculation of the percentage share of one number with another.

We have taken a dataset that contains the value of X and Y. We will determine the percentage share comparing Y with X.

ðŸ“Œ Steps:

• Put the simple formula below on Cell C6 using division operation.
`=C5/C4`

• Finally, press the EnterÂ button.

This is the percentage share after comparing Y with X.

### 3. Calculate Market Share Percentage in Excel

Market share percentage means the market-capturing capability of a company. The formula for calculating the market share percentage is given below.

We have the dataset of the USA mobile phone market that contains the data of total units sold in the USA and the units sold by the iPhone. We will calculate the market share percentage of iPhones in Excel.

ðŸ“Œ Steps:

• Put the simple division formula on Cell C6.
`=C5/C4`Â

• Then, press the EnterÂ button.

We get the market share percentage of the iPhone. We get the result in the percentage form as we format that cell as shown in method 1.

Read More: How to Calculate Market Share in Excel

## How to Calculate an Amount Against Percentage Share in Excel

Now, we will see the reverse, i.e. the % share is given, and you have to figure out an amount based on it.

### 1. Calculate the Amount of Profit Using a Percentage Share

In this article, we will show how to calculate the amount of percentage share from the total.

Here, we have taken a dataset. It contains the total profit and the percentage share of variable X. We need to calculate the amount of profit of X.

ðŸ“Œ Steps:

• Go to Cell C6 and insert the following formula.
`=C4*C5`Â

• Finally, press the EnterÂ button.

We get the amount of profit against the percentage share of X.

### 2. Calculate Total Value from Percentage Share

Here, our dataset contains the percentage share and the value of that percentage share. We will use that data to calculate the percentage share.

ðŸ“Œ Steps:

• Go to Cell C5 and put the following formula based on the division operation.
`=C5/C4`

• Press the Enter button now.

We just divide the value of the percentage share and get the total amount.

## Conclusion

In this article, we described 4 methods to calculate percentage share in Excel. We also showed the calculation of the market share percentage in Excel. I hope this will satisfy your needs and give your suggestions in the comment box.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Alok Paul

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF