[solved]Count if cell from one column is equal to cell in other column

Originally Posted by José Augusto

Try
=SUMPRODUCT((A:A=B:B)*(A:A<>""))

You should avoid using entire columns as range references with the SUMPRODUCT function. Use small specific ranges.