Quote:
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)
|
I have tried that process, but i want it in the formula. or thats is the only way to do it by quoting ("") the name in order to sum that particular name?