How to count the number of zeros in a set of digits?

Question

Google Sheets

There is a set of numbers, you need to count the number of zeros. They may, of course, not be.
10091976336314
In this case, there are two zeros and at the output you need to see the result written in the text in the feminine gender:
two.
Link to the table:
https://docs.google.com/spreadsheets/d/1vqKnsN_8qQ... The
result is also important, how many digits except zeros.
In this example, the result is:
12
It is possible to calculate one thing first, and then another by subtraction. The order is not important to me, the main thing is to get "two" and "12" from this example.
Is such a problem solved?

Answer 1

You can use LEN and regular expressions to count the number of digits.
=LEN(REGEXREPLACE(TO_TEXT(A10);"[^1-9]";""))
To display zeros, the same thing.
=LEN(REGEXREPLACE(TO_TEXT(A10);"[^0]";""))
To write the number of zeros in words, you need the NUMBERTEXT extension

=NUMBERTEXT("cardinal-feminine "& LEN(REGEXREPLACE(TO_TEXT(A10);"[^0]";"")))