# Trying to work out percentage in a column

#### Welchb01

##### New Member
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

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
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

Last edited:
Hi & welcome to MrExcel

Excel 2013/2016
ABC
1NameApplied
2Tom PearceY0.571429
3Bill BrewerY
4Jan StewerN
5Peter GurneyY
6Peter DavyN
7Dan'l WhiddonN
8Harry HawkeY
Template
Cell Formulas
RangeFormula
C2=COUNTIF(B:B,"Y")/(COUNTIF(B:B,"?*")-1)

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

Glad we could help & thanks for the feedback

Replies
2
Views
135
Replies
0
Views
178
Replies
1
Views
297
Replies
4
Views
222
Replies
8
Views
218

1,203,605
Messages
6,056,269
Members
444,853
Latest member
sam69

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back