Counting

[Guest]

I really need help here.

I need to count how many times a number or portion of that number is in a
specific cell. IE: A1 is 101 I need to know how many times 10 or a portion
of 10 is in that number. The answer in this case would be 11. If the
value of A1 is 90 the answer would be 9.

Can anyone help??

 

[Tim879]

Try this formula to see if you get what you need.

=ROUNDDOWN(A1/10,0)
Value Result
901 90
101 10
10 1
999 99

 

[JE McGimpsey]

One way:

=CEILING(A1/10,1)

 

[Guest]

=ROUNDUP(A1/10,0)

Tim made a mistake

Try this formula to see if you get what you need.

=ROUNDDOWN(A1/10,0)
Value Result
901 90
101 10
10 1
999 99