[One-line post alert]
To do the above, use the formula below:
=countif(cell reference of list B, cell reference of list A item)
Excel Hack 24: Count how many times item A appears on list B
