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

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. 

Thanks

jim

You can achieve this on your form https://www.jotform.com/62558759684981 by using the Assign Calculation value option on the fields.

User guide: https://www.jotform.com/help/301-How-to-Assign-Calculation-Value

I.E. 

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.

Thanks.

Please test this form https://www.jotform.com/62889281887983

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 https://www.jotform.com/62889281887983 you can clone it .

User guide: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

Let us know if you need further assistance.