Hi Everyone,
I would like to seek for your help in in getting the percentage of people who answered yes. Let's say on below table, 80% answered Yes. i would like also to know the breakdown of the respondents. Like how many (in percentage) from the respondents came from US, germany, China etc.
i would like to have a button to click then a message box will appear containing the percentages.
Please help.
Thanks,
Mike
what do you class blanks as
=countif(D2:D11,"yes")/countA(C2:C11)
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi there,
See if the attached workbook does what you need.
Hope this helps - please let me know how you get on.
Regards,
Greg M
Thanks guys!
Hi again,
Many thanks for the Reputation increase - much appreciated
You're welcome - glad I was able to help.
Regards,
Greg M
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks