Thanks for the fast reply
I looked at all possible solutions even this sumproduct,but you got to admit
it's not the obvious choice,a math function instead of lookup,compare,count
and such.

"Bernie Deitrick" wrote:

=SUMPRODUCT(--(B2:B100=C2:C100))

HTH,
Bernie
MS Excel MVP