EdwinMerced

Countif Unique values across multiple fields

Discussion created by EdwinMerced on Sep 15, 2015
Latest reply on Sep 16, 2015 by EdwinMerced

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.

Outcomes