Hey Mark,
If you want to give Bob the credit, you should mark this question "answered."
--
Anne Murray


"Mark B" wrote:

=COUNTIF(Sheet2!A:A,B1)

Thanks Bob, that's great...