I need an average for certain criteria in Excel 2007
I am trying to find an average number of days it takes to complete a task.
Column A has the agent name
column B has the date assigned
Column C has the date completed.
I want to average up the information for say, Agent John Smith across a large range. I will be referencing the agent names by a list in a cell range so i would need it to refernce A5 for "John Smith" (I have 183 agents so I dont want to have to type their names in a formula.