Similarities in 2 columns

I have 2 columns in excel:

COL1 COL2
1 1
1 1
1 0
3 2
2 2
3 3

How do I get the frequency of 1 = 1?
(In this case it's 2)

Thanks... That helped!

Another question?
How do you count if the first variable OR second variable OR both are 0(ZERO)?
example:

1 0
0 1
0 0
1 1
1 1
2 2

The result would be:
[2:2] = 1
[1:1] = 2
[0] = 3