GFWIW, you could just use COUNT instead of SUMPRODUCT(--ISNUMBER(...)) since COUNT ignores errors anyway
Originally Posted by Aflatoon
Given the nature of all the special characters, you could also use FIND instead of SEARCH and then omit the additional tildes.
I agree, the original formula is not optimal.
Click here for a guide on how to add code tags
Click here for a guide on how to mark a thread as solved
Click herefor a guide on how to upload a file with your post