Background: I'm brand new to Zoho and have very limited programming experience.

I need to count some records based on if they meet certain criteria. What I would like to know is: is this possible to accomplish without learning DELUGE (which would be time-consuming)? I can't see anything obvious myself and a look through the user guide does not show anything obvious either.

We have some trainees but I only want to count them if they have completed trainings A, B, C and D from one category and one of trainings X, Y and Z from another category. If they have not met this definition I do not want to count them.

I've laid it out in the form as:

Field 1:- First Name : "single line text"

Field 2:- Last Name : "single line text"

Field 3:- Required Training set 1: "check box" (containing the options A, B, C, D)     - trainees must complete all of these

Field 4:-Required Training set 2: "check box" (containing the options X, Y, Z)           - trainees must complete at least one of these

Thanks!