I am having difficulty analyzing data in table form: data on Sheet1
answer Sheet2
1 2 3
A B C D
1 | 4 0 0
2 | 0 8 0
3 | 0 4 4
4 | 0 0 0
5 | 0
Above deals with Sheet2
I have 4 - 8 - 4 as frequency using this formula
=COUNTIF(Sheet1!B2:H200,"1") for number 1 is 4 found in B2
=COUNTIF(Sheet1!B2:H200,"2") for number 2 is 8 found in C2

However, when I expand this formula to find matches such as
how many matches are there for 2 matching 1 should be "0" in
this case, I am stuck

=COUNTIF(Sheet1!B2:H200,"2")-COUNTIF(Sheet1!B2:H200,"1")-B2

This way I would know how compatable 1 is of 2 or how many times
this combination matches. Similarly 1 is of 5 etc.
1:1 2:2 3:3 etc. will always reflect frequency.
Thus creating a table of matches/compatable and frequency

Any help would be appreciated