count how many times value repeat on list appsheet

[leentsuki]

I have several columns with REF values, i manage to extract those REF values in a LIST.

In my REF TABLE(parent), i wanna count how many time every record appers in the list.

I try with COUNT() and SELECT() but not results so far. 

[TeeSee1]

I do not clearly understand what you are trying to accomplish

Parent

• pid
• related children (REF_ROWS)

Child

•  ch id
•  pid (ref)

Where is the LIST?

You say several ref columns. are these in one child table with many different parent tables?

"many time every record appers" <- what record are you referring to?