Calculate % of responses

P

PeeZee

I have dumped results of a questionairre into Excel and have been trying to figure out how calucalute the percentage of our repsonses. We had a list of four options and had to rank our preference for 1st, 2nd, 3rd and 4th choices. How can I calculate the % selecting each option for each choice preference?
 
A

Alex

PeeZee

If your responses are : 1st A1, 2nd A2, 3rd A3, 4th A

In say A6 sum A1:A

In B2......=A1/$A$

and format as %
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Percentage Increase 11
Office 365 documents default header 1
nested "If" fuction 4
How to Rank Name? 4
Restrict choices in one drop down list by response to another 4
Problem with Upload Center on Office 2010 when using encrypted area on disk 0
Counting number of medals per athlete 1
Formula for rating results 3

Top