How can I count the number of attendees in a list of entries

  • Profile Image
    Asked on October 15, 2016 at 06:21 PM

    I tried to search for this but "count" and "entries" kept bringing me to submission limits on forms.

    What I'd like to do is separetly count the number of Male and Female students, as well as the total number of attendees (this includes adults).

    I have a manual entry for M and F students and Total attending but don't trust the public with math. 

    I'd also like to count the non-students. This could be Total -(M+F) or a count of anyone that isn't classified as Student.

    I know it should be simple, but I'm not making it work. 



  • Profile Image
    Answered on October 16, 2016 at 01:15 AM

    You can achieve this on your form by using the Assign Calculation value option on the fields.

    User guide:


    For the type field which you will use to count which type are 'Students' you can do like this..

    ----    - 0

    Sponsor - 0

    Chaperone -0

    Student - 1

    Presenter - 0

    Committee -0

    Guest - 0


    For Gender field to determine count of F or M, simply assign 1 for F and 0 for M


    then use the form calculation widget for all calculations.

    Total students:


    Since in Gender only F=1 you can also get total by adding all the fields (same to formula of Type)

    Formula for M = Type - F    <--- to get total count of M students


    I'll create a demo form and get back shortly so you can try.





  • Profile Image
    Answered on October 16, 2016 at 02:16 AM

    Please test this form

    it work like this



    I have modified the previous calculation value for the Type I mentioned. The correct now is like this

    ----    - 0

    Sponsor - 1

    Chaperone -1

    Student - 1

    Presenter - 1

    Committee -1

    Guest - 1



    I also now have assigned calculation value to "Years Attending" since that is the only means I can distinguished 'Students' from the 'Type' 




    To better review the test form you can clone it .

    User guide:

    Let us know if you need further assistance.