How to count the times a value occurs

[xayala]

In my sheet I am trying to see how many times a value appears in a range of values. An example would be how many times the value"1" occurs between 60-120. The problem is I want the single digit not just the value 1. So in the example if 61,71,81, etc occur I want to know how many times 1 occurs

 

[steve the fish]

Hi, maybe try this:

=LEN(TEXTJOIN(,,A1:A10))-LEN(SUBSTITUTE(TEXTJOIN(,,A1:A10),1,""))

 

[xayala]

Hi, maybe try this:

=LEN(TEXTJOIN(,,A1:A10))-LEN(SUBSTITUTE(TEXTJOIN(,,A1:A10),1,""))

I cant get mini sheet to work but ive attached photo, the command you advised did not seem to work

 

[steve the fish]

I dont understand what thats doing compared to your query.

 

[xayala]

I dont understand what thats doing compared to your query.

In the photo in each "number" column, I need to find how often each number occurs in the range. for the range A2:A38 for example I need to see how often 1,2,3,etc occurs even if they are in double or triple digit number like 60,278

 

[steve the fish]

Thats what i gave you. Doesnt work doesnt help me as i cant see the result.