How to Calculate Percentages of Total in Excel

In this tutorial, you will learn how to Calculate Percentage of Total.

A very common scenario is when you have a total in a single cell at the end of a table. If you are trying to calculate the percentage based on that cell, here is a quick way to do it.

Type = then select the cell next to it. Add a divided sign then type $B$10. This is the location of the total number. We use a relative cell position for the first one but want the total number to be always the same cell. Next, we take the bottom right square of this cell and drag it down as needed. This will calculate the amount across multiple lines.

Even if working with percentages has never been your favorite kind of math, by using these basic percentage formulas you can get Excel to do the work for you!

❓💬 What other excel tutorials would you like to see? Let us know in the comments below.

#HowTech #Excel #Percentages
--------------------------------------------------------------------------------------------------------------

[_pingu]

The only direct to the point video! Thank you!

[snttsbi]

Very easy to follow and understand. I appreciate the "plain vanilla" explanation!

[HanselHernandez-eevn]

Thank you very I'm doing college work, and I got stuck on some questions, and this was very useful.

[abdulkhan]

Thank you sir, i was looking for this formula

[archanaramachandra]

Thank u so much...it was really of so much use to me..

[merontekie]

Thanks that's very helpful and direct

[ulugbeknur]

Super useful. Concise, clear and an excellent example. It worked! Thank you so much.

[ygeeblkfoe]

I'm going to get 100% because of You

[BluCherri]

Is there a way to have the percentage auto populate if you don’t have the values entered? Your example, lets say you wouldn’t have calculations for Feb-Dec until the end of that said month, could you enter a formula that would add the previous month AND also include the current month’s numbers to come up with a percentage?

[felicialevy]

which formula we use to calculate the sum of %total when there are both negative and positive percentages?

[dginicola]

Thank you so much! You are awesome!!! I'm going to watch the ads for you ;) haha!

[velse.health]

Can you make a video like this but then breaking it down by % showing percent by daily, weekly, monthly. Thanks!

[dbmnfinity]

how can I get the percentage of names of my employees that show up on an excel sheet? as an example one person name shows up 20 times, another shows up 10 and the third shows up 80 times? not good with excel, so I'm asking question to find out please.

[sitihcf]

What do you mean by type the following?

[michaelsiracusa]

Could you please make an Excel video that shows (for example 3, 568.44) then add sales tax to it plus a terminal fee to reach the final amount?

[keladv]

Question if the $ sign is too far from its letters how can I make them closed together with the cell like this sample i hope you can give answers thanks

[fabulously]

is there a way to make the percentages more precise, for example 0.01%?

[alycook]

How do you calculate a % of the Total as in I want to work out what 33.33 percent of a total is ?