Excel Percentage Of Total - 2579

How to calculate a percentage of total in Excel.

Common search terms answered by this video:
How to add percentages to sum in Excel
how to calculate percentage of a sum in Excel
how to change a percentage on a sum on Excel
how to do a percent sum in Excel
how to do a percentage of a total sum on Excel
how to do a percentage sum in Excel
how to do a percentage sum on Excel
how to do an percentage sum on Excel
how to do percentage sum in Excel
how to find a precentage of sums in Excel

Table of Contents
(0:00) Add a Total in Excel
(0:10) Division formula in Excel
(0:22) F4 to add dollar signs in Excel for absolute reference
(0:32) Formatting as a percentage with 1 decimal place
(0:37) Double-click Fill Handle to copy formula
(0:45) Wrap-up

Transcript of the video:

Get a Percentage of Total in Excel. Let's do a percentage of total in Excel.
First, let's put the total in. So I choose the total cell.
Hit the AutoSum and accept that. Come up to the top.
What we're going to do equal sign point to the very first person's sales.
Slash for divide.
And then come down here and click on the total cell Right now, it's B18.
We have to press F4.
On some computers, that's Function+F4 Or if you can't do it, just type $B$18.
To make sure that that part of the formula always points at the Grand Total. Format that as a percentage.
I like to put one decimal place. Double Click to copy it down.
Now we can see that Andy got twelve and half percent, one-eighth of the total.
If you like these videos, please, down below, Like, Subscribe, and Ring the Bell.
Feel free to post any questions or comments down in the comments below.