For counting substrings with the COUNTIF function
... in the criteria, you can use wild cards ... e.g. "*ABC*" ... where * can be any length of characters or i think "?" works for single characters but i don't have excel running on linux to check
... in the criteria, you can use wild cards ... e.g. "*ABC*" ... where * can be any length of characters or i think "?" works for single characters but i don't have excel running on linux to check