Did you have a look at Data Subtotals? Perhaps that could do it.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Jim" wrote:

I'm trying to set up a worksheet where I can enter transaction data selecting
an individual sales person from a list. I've been able to use the validation
tool to create the list, now I need to find a way to compile the data into a
single line for each sales person. In other words, salesperson A may have
only 5 of the 50 transactions over the week, and I need to find a way to seek
only those 5 transactions, total them and post them in a cell. I've already
exceeded my meager knowledge of Excel by creating the drop-down menu and have
found myself hopelessly outwitted.