Count differences between 2 cell ranges

{=SUM(1*(CellRange1 <> CellRange2))}
{=SUM(IF(CellRange1 = CellRange2, 0, 1))}
Comparing Two Tables

Built-in Functions

SUM - The total of the numerical values.