Try

=SUMPRODUCT(--(A1:A1000<>B1:B1000))

=SUMPRODUCT(--(A1:A1000=B1:B1000))