Help with Cell formulas please

Originally Posted by Bob Phillips

Try something like this in the results cell

=SUMPRODUCT(--(A1:A100=B1:B100),--(A1:A100<>""))*10

Thanks for your speedy reponse however, being on the nothing to limited end of
the Excel scale, could you possibly explain a little how A1:A100 etc formulas work
then I could alter the values accordingly

Many Thanks

Mr Dim