**papillon88**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!

- JotForm Founder
**aytekin**Here is a good documentation about that:

http://spreadsheets.about.com/od/excelfunctions/qt/average_functio.htm

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**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 4I 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.

Thanks in advance!

- JotForm Founder
**aytekin**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**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 4First. 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.

- JotForm Founder
**aytekin**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.