I have 10 multiple fields (named A1 through A10). These fields only accept values 1, 2 3 or 4 from a Value List. I need to count the amounts of 1s, 2s, 3s, and 4s across all fields (A1-A10). For example: 4-1s, 2-2s, 2-3s and 2-4s

I have used =COUNTIF in Excel to do this but do not see that function in Fielmaker.

Thanks for any help.

Let (

theList = List ( A1 ; A2 ; A3 … A10 ) ;

List (

ValueCount ( FilterValues ( theList ; 1 ) ) & " 1s" ;

ValueCount ( FilterValues ( theList ; 2 ) ) & " 2s" ;

ValueCount ( FilterValues ( theList ; 3 ) ) & " 3s" ;

ValueCount ( FilterValues ( theList ; 4 ) ) & " 4s"

)

)

though you very likely should use a child “A” table with 10 records per parent, rather than 10 fields.