DCOUNT with multiple criteria

Hi,

I have a worksheet, 10 columns (A to J), and + 500 rows, first row are headers, the rest are integer numbers between 1 and 70, no specific order, I can say random.

M1 M2 M3 M4 M5 M6 M7 .....M10
10 17 21 50 54 56 37
17 18 19 24 37 53 50
7 8 26 27 53 56 20
9 10 24 32 35 55 34
4 9 27 31 33 40 45
15 17 38 41 46 54 21
10 19 20 23 31 44 38
1 5 10 13 31 54 46
9 37 38 42 50 56 6
6 27 37 41 50 53 18
8 16 24 42 46 50 28
11 28 29 31 49 54 19
19 27 29 35 37 44 24
....

What I need to do is get occurrence between all of them, something like this:

1 2 3 4 5 6 7 8 9 10 11....
1 0 0 0 0 0 0 0 0 0 0 0
2 0 0 0 0 0 0 0 0 0 0 0
3 0 0 0 0 0 0 0 0 0 0 0
4 0 0 0 0 0 0 0 0 0 0 0
5 0 0 0 0 0 0 0 0 0 0 0
6 0 0 0 0 0 0 0 0 0 0 0
7 0 0 0 0 0 0 0 0 0 0 0
8 0 0 0 0 0 0 0 0 0 0 0
9 0 0 0 0 0 0 0 0 0 0 0
10 0 0 0 0 0 0 0 0 0 0 0
11 0 0 0 0 0 0 0 0 0 0 0
.....

The table should tell me how many "1" and "2", "1" and "3"... "1" and "70" all the way to "70" and "68", "70" and "69" occurrences are in the data list (M1...M10).
I'm using DCOUNT formula, in an array, it has 70 columns and 70 rows.
The table above shows 0's since the formula I used is not working as desired, criteria seems to be the problem..

Any ideas?... your help will be really appreciated.

Thank you.

Thank you again bud,

I saw where I was screwing it, did what you suggested and seems to work, but something is not right, there are several occurrences that the formula is not counting, most likely the ones with bigger numbers.

BTW, the data set sent doesn´t includes numbers greater than 56, so those occurrences are expected to be 0's, but there are others, like 50-54-56 as in the first row of Data that doesn't appear in the count table (M_CT).

Please see attached file.

Again, your help is really appreciated.

Regards.

Bud....

Thank you.... Thank you.... Thank you....

It works just perfect!!!.

Thank you very much indeed.

Regards.