Multiple Criteria Lookup Function

[tomf1990]

I have data in this format: Agent and Line in Column A and Call number
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 o
line 1, line 2 etc for each agent. I have tried SUMPRODUCT but I thin
because my Line number and Agent are in the same column it returns a
error. Any suggestions

 

[Kevin@Radstock]

Hi

How about the COUNTIF function: =COUNTIF(your_range,"Line1")
or
=SUMPRODUCT(--(your_array="Line3"))