So i have this Formula, and it works great, it finds, and counts instances where a name appears, with a given text from AD:AD in the previous column that has Square brackets.
=IFERROR(INDEX(QUERY({regexreplace('All Report Sheet'!$B$1:$B, "\[|\]",),'All Report Sheet'!$C$1:$C},"select count(Col1) where (Col1 matches '"&JOIN("|",REGEXREPLACE($AD$2:$AD, "\[|\]",))&"') and Col2='"&$A14&"' label count(Col1) ''")))
I have recently seen that it is not counting names with regular brackets so i tried to tweek it to allow that to the Below formula, but i'm having no luck at all, i'm not sure of the issue.
=IFERROR(INDEX(QUERY({regexreplace('All Report Sheet'!$B$1:$B, "\[\]\(\)",),'All Report Sheet'!$C$1:$C},"select count(Col1) where (Col1 matches '"&JOIN("|",REGEXREPLACE($AD$2:$AD, "\[\]\(\)",))&"') and Col2='"&$A65&"' label count(Col1) ''")))
Any Help is appreciated