Question description:
This user has given permission to use the problem statement for this
blog.
Is there a way to total a column of "Yes" answers to determine the number of people that responded with "Yes"?
Solved by G. Y. in 10 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
15/11/2017 - 11:13
Hi, It's pleasure to help you today:)
User
15/11/2017 - 11:14
thanks
Excelchat Expert
15/11/2017 - 11:14
As per the description stated, there is possible way of getting the count of people with "Yes" answer
Excelchat Expert
15/11/2017 - 11:16
I am going to use countif function to get the count of "Yes"
Excelchat Expert
15/11/2017 - 11:16
=countif(B2:B5,"Yes")
Excelchat Expert
15/11/2017 - 11:16
It contains the range under consideration and the condition of check
Excelchat Expert
15/11/2017 - 11:17
You can adjust the range based on the requirement.
Excelchat Expert
15/11/2017 - 11:17
And the condition need to be placed in double quotes
Excelchat Expert
15/11/2017 - 11:18
Because, condition is a string.
Excelchat Expert
15/11/2017 - 11:18
Hope, this explanation helps to resolve the stated problem
User
15/11/2017 - 11:19
Understood. Thank you so much! I will now learn more about this service and tell others about it. Thank you for your time and expertise.
Excelchat Expert
15/11/2017 - 11:19
That is great to hear :)
Excelchat Expert
15/11/2017 - 11:19
Have a great day. Please visit Got It pro for new queries.
Excelchat Expert
15/11/2017 - 11:20
Please leave a valuable rating after ending the session.
User
15/11/2017 - 11:20
You got it; will do!
User
15/11/2017 - 11:23
Have a great rest of your day/evening!
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.