# Count the percentage of a question in excel?

• papillon88
Asked on December 28, 2010 at 11:19 PM

hi!

I have done a survey with jotform, then i imported it in excel. And i tried to make the percentage of some answer wich the alternativ were a range from 1-5, but i dont get it.

Can someone help me to resolve this?

ThankS!

• aytekin
Answered on December 30, 2010 at 04:15 AM

Here is a good documentation about that:

You can also use the "Visual Report Designer" available on JotForm "Report" types. It allows you to create charts and calculate average responses on surveys.

• papillon88
Answered on December 30, 2010 at 01:53 PM

This link you gave me, explains how to get the average of all answer, and not the percentage of EVERY POSSIBLE answer.

What i wanted is get the percentage. For example.

I have a question where i can rated it with a range 1-5.
P1 rated it with 4
P2 rated it with 3
P3 rated it with 1
P4 rated it with 4
P5 rated it with 3
P6 rated it with 4

I want to do the following in excel

Rated with 4: 50%
Rated with 3: 35&
Rated with 1: 15%

The "visual repport designer" is only one page and i have more than 15 answered i want to count the percentage. Wich mean that if I resize the reportage, they will be too small.

I hope you understand.

• aytekin
Answered on January 01, 2011 at 11:46 PM

In that case, you should use Excel. I posted a link on how to find averages on it above.

You can get an excel report in the same way you get a new report: Select your form on My Forms page, click on Reports and then click on "Add New Report". Then select the Excel option.

• papillon88
Answered on January 02, 2011 at 04:37 AM

I get it my way in excel.

Instead of Average function i used the COUNTIF(), and i got the value of amount answered. Exactly how i explained above. Then i could get the percentage.

I'll explain so other can solve the problem if they have it.

I have a question where i can rated it with a range 1-5.

Field
A1 -    P1 rated it with 4
A2 -    P2 rated it with 3
A3 -    P3 rated it with 1
A4 -    P4 rated it with 4
A5 -    P5 rated it with 3
A6 -    P6 rated it with 4

First. To count the number of people who rated with 4,  do the following;

=COUNTIF(A1:A6;(4))

You will get = 3

If you continue with the other answer, then u marked them and choose a diagram, you will get the percentage.

Thanks anyway Aytekin.

• aytekin
Answered on January 03, 2011 at 06:46 AM

You should be able to that with the Visual Report Builder. If you see the screenshot I posted above. You will see that there is a number near each answer. For example, do you see "Satisfied (4)". That means 4 people selected the "Satisfied" option.