Thread: Counting
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tim879 Tim879 is offline
external usenet poster
 
Posts: 208
Default Counting

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




On Aug 15, 1:04 pm, John wrote:
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??

--
John Chaput