problem calculating psychomatrix in excel ??

i tried to calculated psycho matrix in excel based data but im confusing how to make it in excel

For example the date of birth in cell e3-f3 : 05/12/1979 - (December 5, 1979.)
1) Add the digits of the day and month of birth: 5 +1 +2 = 8.
2) Add the digits of the year of birth: 1+ 9+ 9+ 7 = 26.
3) Add the resulting numbers: 8+ 26 = 34 - here we have the first working number.
4) Add the digits of the first working number: 3 + 4 = 7 - here we have a second working number.
5) From the first working number we are subtracting the doubled first digit of the date of birth:
34-2 * 5 = 24 - here we have the third working number.
6) Add the digits of a third working number: 2 + 4 = 6 - here we have a forth working number.

The first series of numbers: 5121979
The second series of numbers: 347246

After counting how many digits are there in both rows, we can form the table:
11 ... 44 ... 77
22 ... 5 ... No 8
3 ... 6 ... 99

the table data will appear in cell C30 - E32 in my excel like
cell c30 = count how many 1s
cell c31 = count how many 2s
cell c32 = count how many 3 s
cell d30 = count how many 4s
cell d31 count how many 5s
cell d32 = count how many 6s
cell e30 = count how many 7s
cell e31= count how many 8s
cell e32 count how many 9s

cross posting
https://www.excelguru.ca/forums/show...atrix-in-excel