Countif ?

[shortpour]

I have two columns in excel and i need a count of how many rows do not have the exact information in both columns.

Column A Column B
206 205
205 205,206
(blank) 204


Thanks in advance

[Pete_UK]

You could put a formula like this in C1:

=(A1=B1)*1

then copy down, which will give you a series of 1s and 0s, then in D1 you could have this formula:

=SUM(C:C)

to give you the count of identical records.

Or, if you want one formula, you can use this:

=SUMPRODUCT(--(A1:A100 = B1:B100))

adjust the 100 to suit how much data you have.

Hope this helps.

Pete