Formula to Count

[ststern45]

I have a list of 10 random values (000 through 999) in cell range A1 through A10.

In any of the 3 positions
In Cell B1 I wanted to find out how many of the values in cell range A1 through A10 contain the value of 0
In Cell C1 I wanted to find out how many of the values in cell range A1 through A10 contain the value of 1
In Cell D1 I wanted to find out how many of the values in cell range A1 through A10 contain the value of 2
In Cell E1 I wanted to find out how many of the values in cell range A1 through A10 contain the value of 3
In Cell F1 I wanted to find out how many of the values in cell range A1 through A10 contain the value of 4
In Cell G1 I wanted to find out how many of the values in cell range A1 through A10 contain the value of 5
In Cell H1 I wanted to find out how many of the values in cell range A1 through A10 contain the value of 6
In Cell I1 I wanted to find out how many of the values in cell range A1 through A10 contain the value of 7
In Cell J1 I wanted to find out how many of the values in cell range A1 through A10 contain the value of 8
In Cell K1 I wanted to find out how many of the values in cell range A1 through A10 contain the value of 9

Thank you in advance

 

[bebo021999]

B1, drag accross:

=SUMPRODUCT(--ISNUMBER(SEARCH(COLUMN()-2,$A$1:$A$10)))

 

[ststern45]

Thank you.
I will apply your formula later this morning.

 

[Phuoc]

Or try this in B1:

=LEN($A$1&$A$2&$A$3&$A$4&$A$5&$A$6&$A$7&$A$8&$A$9&$A$10)- LEN(SUBSTITUTE($A$1&$A$2&$A$3&$A$4&$A$5&$A$6&$A$7&$A$8&$A$9&$A$10,COLUMNS($B$1:B1)-1,""))