Hi All,
Good Evening. I need help to calculate the semicolon count in a range. The array contains data which is separated by a semicolon.
Column A
A;C;D
A;C
A;D;F;G;R
A;E;F
A;F;G;H;Y;T
A;G;T;Y;U
I want to calculate how many cells has more than 2 semicolons in a range. For the above example, the answer would be 3. I have tried this "=SUMPRODUCT(LEN(A:A)-LEN(SUBSTITUTE(A:A,";","")))" formula. but I don't know how to include the countif formula in this. Thanks in advance!
Bookmarks