Formular to count all votes

  • Profile Image
    ComKat
    Asked on October 04, 2013 at 07:06 PM

    Hi

     

    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. ***
    name1
    name2
    name4
    name2
    name1
    name2

    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 -.- 

  • Profile Image
    Cesar
    Answered 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.

  • Profile Image
    ComKat
    Answered 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 :)

  • Profile Image
    jedcadorna
    Answered on October 05, 2013 at 12:55 PM

    Hi,

    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.

    Thanks,

  • Profile Image
    ComKat
    Answered on October 06, 2013 at 06:46 AM

    Thanks seems to work perfect! :D

  • Profile Image
    jedcadorna
    Answered on October 06, 2013 at 08:02 AM

    @ComKat,

    That's great to hear. Don't hesitate to contact us should you have any issues/questions about JotForm.