KuraiChikara
Board Regular
- Joined
- Nov 16, 2016
- Messages
- 111
- Office Version
- 2013
- Platform
- Windows
Hello, I am looking to perform a SUMIF but with names. For example, say there are different supervisors in column A and I want to find the amount of agents a particular supervisor has listed in column B (without doing a filter).
Say supervisor JOHN CLOUD is in Column A2 and then in random rows after that and he has 12 agents. Those agents are in column B formatted this way: Smith, Jane.
I want to be able to to a SUMIF to look for John the supervisor and pull the total of people under him from column B but I dont know how to SUMIF text.
I used this formula:
=SUMIF(A$2:A$600,A2,B$2:B$600)
But it just results in pulling a zero (0).
Say supervisor JOHN CLOUD is in Column A2 and then in random rows after that and he has 12 agents. Those agents are in column B formatted this way: Smith, Jane.
I want to be able to to a SUMIF to look for John the supervisor and pull the total of people under him from column B but I dont know how to SUMIF text.
I used this formula:
=SUMIF(A$2:A$600,A2,B$2:B$600)
But it just results in pulling a zero (0).