Calculate the number of occurrences of specific text value over several fields
I'm using Filemaker Pro 9.
I have a table that has the names of up to four different people (each person entered in a separate field). Next to each name I have a set of radio buttons to select gender, Male or Female (M or F).
I need two fields at the bottom, one calculating the total number of males (M) on the form, and one calculating the total number of Females (F).
I am so far unable to find a way of doing this efficiently.
Can anyone help?