View Single Post
  #1   Report Post  
tomf1990 tomf1990 is offline
Junior Member
 
Posts: 3
Exclamation Multiple Criteria Lookup Function

I have data in this format: Agent and Line in Column A and Call numbers in Column B

Agent Calls
Jonathan Smith

Line 1 1
Line 2 6

Sarah Jones

Line 1 2
Line 2 4
Line 3 8


I am looking to get a formula that gives me the number of calls taken on line 1, line 2 etc for each agent. I have tried SUMPRODUCT but I think because my Line number and Agent are in the same column it returns an error. Any suggestions?