I'm going to show you how to create statistics from the values of a
drop-down list I was approached the other day by someone and they wanted to
keep their statistics from their newly created sheet regarding the type of
people that type of applicants that they are receiving
fortunately they created their drop-down list using referencing data from another
sheet in my description I will link to a video where I have shown you how to
create our drop-down list referencing another sheet so in this is in the
referred column what you see let's click on this and you can see that they have a
number of different options that can be selected regarding this so I know that
it was created on another sheet so let's go to the other sheet and here we have
the items that better reference in that drop-down list so to figure out how many
of each of these are done let's use the countif function and so we'll go we'll
go click our insert function button here and we'll select count it and then
you'll say okay and I'm going to select the range and so now what I'm going to
do is I'm going to go to sheet registered person and I'm going to click
on the C column and now I'm going to click into the criteria box here and
then what I'm going to do is select the the item that I'm next to there which is
government agency and then I'm going to say ok and so the result of that is one
and so let's drag this down so we can get all of them and so we get to the end
of other and we only have two things right on this sheet right now but let's
figure out what the total is so let's go to the Home tab click on the autosum and
say ok and there you have two so in order to figure out the percentage let's
go equals and we're gonna go this value divided by the total and we're going to
absolutely reference act and how we're going to do
those we're going to press the f4 key on our keyboard and then we're gonna press
enter now we point five doesn't mean anything to list so let's go to the Home
tab and let's format it as a percentage okay
so now we can drop this down and there we go
so now in order to create a report all you would need to do is you would need
to hide this column here because you don't really need to see the one or the
two or whatever and so we're gonna hide this and then if we went to print
preview this is going to look pretty pretty pretty nice and if I enlarge it
when you enlarge it you can see that it's just got the agencies and the
percentage rate beside it and so that report looks fairly handy and fairly
professional and besides the other thing is is this will be an ongoing report so
let's go back to my data so I'm going back to mine a - now and now let's enter
in someone else here so let's say Joe
and let's choose let's choose maybe give him an agency
for him as well okay so now if we look at our statistics they will look
instantly updated it's gone from 50% to 67% and the other one has changed to 33%
so whatever you do to your worksheet it will absolutely always update your
statistics so that is how you create statistics from a drop-down list please
subscribe