Maybe this is more intuitive....

=SUM((B2:B100=C2:C100)*1)

Entered using Ctrl-Shift-Enter

HTH,
Bernie
MS Excel MVP


"Medikto D" wrote in message
...
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