Trying to work out percentage in a column

[Welchb01]

Hello,

My name is Byron and I have been given a task and I am having some trouble. I have just joined up today to ask for some help. I have had a go at searching for different posts but cant seem to find what I am looking for, so I hope what I want to achieve is even possible.

I have a spreadsheet that lists all the people who have visited our nursery. I have a column with Y and N in various rows. Y for the people that visited and applied and N for the people that visited but didn't apply.
I would like to work out the percentage of the people that have applied and have it at the bottom of the spreadsheet, so at a glance our manager can look and see that out of all the visits so far the percentage that have applied?

I hope this makes sense, I only know the basics in Excel if any at all.

Thank you.
Byron

 

[tyija1995]

Hi Byron,

Try this formula:
=COUNTIF(A1:A100,"Y")/COUNTA(A1:A100)

Where cells A1:A100 would be where your data is. (Change this range depending on where your data actually is)

Then format as a percentage

 

[Fluff]

Hi & welcome to MrExcel
How about

Excel 2013/2016
	A	B	C
1	Name	Applied
2	Tom Pearce	Y	0.571429
3	Bill Brewer	Y
4	Jan Stewer	N
5	Peter Gurney	Y
6	Peter Davy	N
7	Dan'l Whiddon	N
8	Harry Hawke	Y
Template

Cell Formulas
Range	Formula
C2	=COUNTIF(B:B,"Y")/(COUNTIF(B:B,"?*")-1)

 

[Welchb01]

Hello.
Thank you for your quick replies I really appreciate it.
I had a go with both of the formulas suggested and I was so excited to see the result I was after.
This has really helped me out thanks again.
I will be sure to come back should I face any other hurdles.
Byron

 

[Fluff]

Glad we could help & thanks for the feedback