Count if column 1 matches column 2

Jacob Slaathaug

I'd like to create a formula in a summary cell at the top of my sheet that counts rows in which the value in 1 column matches the value in another column at the same row. I'm hoping to do this without creating a helper column.  

Example:

Col1    Col2

1          1            =1

2          2            =1

3          0            =0

4          3            =0

5          5            =1

I'm guessing there is an obvious answer, but I can't find it. 

=COUNTIF(Col1:Col1, = ????)

I've tried using Col2@row, VALUE(Col2@row), some @cell combinations, but no success.

Any help would be appreciated. Thank you.

Paul Newcome

The only ways I have been able to make work involve a helper column. If you don't want a helper column to be seen on the sheet, you could always build it and then just hide it.