Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have a column of percentages (11 in a column). I want to have a percentage at the bottom of the column that tells me how many of the entries are = to 100%.
Solved by X. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 15/06/2018 - 12:18
Hi there. Welcome to Got It Pro! I'm Joel.
User 15/06/2018 - 12:18
Hi Joe
Excelchat Expert 15/06/2018 - 12:18
How may I help you?
Excelchat Expert 15/06/2018 - 12:19
I see from your problem description. You want to have the percentage of the entries which are equal to 100%, is that right?
User 15/06/2018 - 12:20
I have a column of percentages and I would like to have a single Percentage at the bottom of the column that tells me the percentage of cells that equal 100%
Excelchat Expert 15/06/2018 - 12:20
Can you show me your data so we'll have something to work at
Excelchat Expert 15/06/2018 - 12:22
Okay. Based from your data in Column B, you have 4 100% out of 7.
User 15/06/2018 - 12:22
Excelchat Expert 15/06/2018 - 12:22
But in percentage format right?
User 15/06/2018 - 12:23
Excelchat Expert 15/06/2018 - 12:23
Like that in C8. 4 out of 7 which is 57%
Excelchat Expert 15/06/2018 - 12:23
Okay. Let me check on it.
Excelchat Expert 15/06/2018 - 12:24
Can you see my solution in B8?
User 15/06/2018 - 12:25
ok - see it
User 15/06/2018 - 12:26
give me on sec.
Excelchat Expert 15/06/2018 - 12:26
I used the COUNTIF and COUNT function. Let me explain more about it so next time you'll be able to use it yourself.
User 15/06/2018 - 12:28
That will work - Much Thank you!
Excelchat Expert 15/06/2018 - 12:28
COUNTIF is used to count the number of entries (as in your problem) with certain criteria. 2 parameters are involved in here. 1st is the range of the entries ($B$2:$B$7), and 2nd is the criteria which is 100%.
Excelchat Expert 15/06/2018 - 12:28
Sure thing. Do you want me to explain further?
User 15/06/2018 - 12:29
All Ears
Excelchat Expert 15/06/2018 - 12:29
Okay. The COUNTIF already gives you the number of entries matching the criteria which is 4.
Excelchat Expert 15/06/2018 - 12:30
Next function is COUNT which only counts the numerical entries in the range; therefore, gives the result of 7.
Excelchat Expert 15/06/2018 - 12:31
I'm glad I was able to help you.
Excelchat Expert 15/06/2018 - 12:31
Did you understand now the COUNTIF and COUNT functions?
User 15/06/2018 - 12:32
I really appreciate you help! Thank you.
Excelchat Expert 15/06/2018 - 12:33
No problem. Please give me a high rate and a nice feedback (comment) so next time you consult here I have a high chance of connecting with you again.
Excelchat Expert 15/06/2018 - 12:34
You're welcome. And always remember, if you have an Excel problem, we 'Got It' you covered! Have a nice day!

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc