Count if: Compare 2 ranges and count where cells in same row differ

[ExcelFed]

Column A has current building, column b has future building. Would like to count the number of changes without adding a separate column with an if statement.

[Jonmo1]

Try

=SUMPRODUCT(--(A2:A12<>B2:B12))

[ExcelFed]

thanks. that worked. can you explain the "--" what that does?

[Jonmo1]

You're welcome.

(A2:A12<>B2:B12) in sumproduct is creating an array of TRUE or FALSE values
The -- converts True/False to 1/0
True=1, False=0
it then adds them up.