Someone please help me get the "=COUNT(DISTINCT(COLLECT(" formula correctly?!

ss_roli

HI there team,

Trying sum up the Summary screenshot by unique Shops/Customer registered. Data is coming from the different file which is a registration file, and for some reason I cannot get the formula to work. Attaching a sample.

thank you!

Sample_1.xlsx

Jeremy C

Have you tried something like this? =COUNTM(DISTINCT(CHILDREN()), ", ")