if data is in col a rows 2 through 108 and salespersonnel is in col B:

put this formula in any cell:
=COUNTIF(B2:B108,"=Sam Brown")

You can exchange Same Brown with the name you are looking for.

hth


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=469849