I have a matrix table with 7 options someone can select for themselves and for their children. I want to get a count of how many times Column 2 was selected for all of the children, but exclude the selection for “yourself”. Is it possible to do a count of the specific answer in column 2 , but exclude the selection for “yourself” in the statments? I plan on using the count from this question as an embedded data field so I can compare the count to another field to make sure that the counts match.

Hi,You could use scoring and create a category like this. You can then pipe in the score in an ED field.

Thanks Vincent. Got it to work exactly as I needed.

Count specific column from matrix and exclude specific row

Count specific column from matrix and exclude specific row | Experience Community