Originally Posted by MyVeryOwnSelf[_2_]

Here's an easy way, but it doesn't use the functions you mention.

With the names in column A, select that column and use
Data Filter AutoFilter
This lets you choose a person using a pull-down list in A1.

With sales numbers in column B, use this to calculate the sum:
=SUBTOTAL(109,B:B)