Użytkownik "bj" napisał w wiadomości
...
=sumproduct(--(A1:A100<B1:B100))
will count the number of non equal pairs in rowns 1-100 in columns a and B
note you cannot use A:A<B:B in sumproduct
the--( chnages the logical true false to a numeric 1 0


great, super, wow :)
thanks

tomek