=SUMPRODUCT(LEN(INT(A1:A100))-LEN(SUBSTITUTE(INT(A1:A100),1,"")))


"tpmax" wrote:

Fantastic! Is there an easy way for me to control the function so that it
only counts values to the left of a decimal point (e.g., 11.0101 would only
count 2)?

"Teethless mama" wrote:

=SUMPRODUCT(LEN(A1:A100)-LEN(SUBSTITUTE(A1:A100,1,"")))


"tpmax" wrote:

I need to count the number of instances of "1" in a cell range. Here's the
catch, the range may contain more than one instance of it in a single cell,
but I need to account for each independently. So one cell may contain 11 and
the next 111, but I need to count the number of times (in this case, 5) that
the value is displayed.