How to count the number of articles of a certain length in excel?

Question

excel

The task is to understand by the article which supplier supplies it. The key difference between suppliers is that they (thank God) have articles of different lengths. Someone has 36, someone has strictly 11. I found a formula
=СЧЁТЕСЛИ(CODES2;ПОВТОР("?";35)&"*")that counts the number of positions in which the length of articles is more than 35.
Question: is there a way to determine the quantity exactly by a specific length? (not more or less)

Answer 1

=SUMPRODUCT(--(LEN(%ДИАПАЗОН_ГДЕ_СЧИТАЕМ%)=%ДЛИНА_КОТОРУЮ_СЧИТАЕМ%))

for example
=SUMPRODUCT(--(LEN($I$27:$I$31)=3))

In Russian Excel it will probably be like this

=СУММПРОИЗВ(--(ДЛСТР(%ДИАПАЗОН_ГДЕ_СЧИТАЕМ%)=%ДЛИНА_КОТОРУЮ_СЧИТАЕМ%))