Sumproduct And LEN Function To Find Characters In A Range
SUMPRODUCT Sum The Return Value True And False. True = 1 And False = 0 . LEN Function Check The Len For All Cell And Return The Length As Array. For More Detail Please Check Image Below.