- ComKatAsked on October 04, 2013 at 07:06 PM
I would like to know if anyone got a formular to count alle votes for names in excel.
I have about 25 reply's on a form, and its different persons that have been voted on, so if its possible to count the person with most votes, or list alle that have got votes, and how many votes.
Exsample: Question 1. ***
And witth the formular it would maybe say
name1 - 2
name2 - 3
and so on...
I have about 50 questions, and there is about 30 votes in each, so many to count -.-
- CesarAnswered on October 04, 2013 at 09:37 PM
Hello, If the data is properly set you should be able to perform this through Excel by using pivot tables.
If you can please provide a link to your file so that I may work to see if theres any efficient alternative methods. Thank you.
- ComKatAnswered on October 05, 2013 at 09:31 AM
The link to the form: http://jotform.co/form/32705568090860
Its an "Awardsshow", its not the first, and not the last, but first time i using jotform to do this, do hope you can help :)
- jedcadornaAnswered on October 05, 2013 at 12:55 PM
You can try to use =COUNTIF(range, criteria),
Ex. A1: A6 is the cells that has a name field like name1,name2 etc.. A1 would be the start and A6 would be the end where you want the cells to be counted. The "name1" is the field name that you want to be counted.
Please see this guide on where I find the sample formula.
I hope this helps.
- ComKatAnswered on October 06, 2013 at 06:46 AM
Thanks seems to work perfect! :D
- jedcadornaAnswered on October 06, 2013 at 08:02 AM
That's great to hear. Don't hesitate to contact us should you have any issues/questions about JotForm.