AnsweredAssumed Answered

Calculate the number of occurrences of specific text value over several fields

Question asked by zifbox on Mar 22, 2009
Latest reply on Mar 23, 2009 by philmodjunk

Title

Calculate the number of occurrences of specific text value over several fields

Post

Hello, 

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?

  

thanks 

Outcomes