Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
lookup multiple criteria | Excel Worksheet Functions | |||
Lookup Multiple Criteria | Excel Worksheet Functions | |||
Lookup by multiple criteria? | Excel Worksheet Functions | |||
Lookup using multiple sheets and multiple criteria, sorry if 2 pos | Excel Worksheet Functions | |||
Lookup using multiple sheets and multiple criteria | Excel Discussion (Misc queries) |