Hi, I’m attempting to create a file database and I’m running into an issue of how (if at all possible) calculate the number of times a certain set of values occur within different groups.

For example:

There are 4 intern options for high and college students

Opt. A

Opt. B

Opt. C

Opt. D

and I would like to calculate what percentage of 14-15 yrs are enrolled in each program.

Each record(row) has a field(column) for age and program.

In Google Sheets and Excel I can use COUNTIF, but what is the alternative in Airtable, if any?