i have a spreadsheet of aroun 300 lines. Each line contains the name of 1 of 15 agents with an amount paid out to them. I already have the automatic filters so that i can choose each agent but i need a formula so that when i chose agent X and shows me all the lines for him, that a sum shows up for this person.

clear?