I have created a list of agents. When Bob Smith sells a deal and he is listed as the agent, I want all cells that list Bob smith as an agent to add up so that I can see how many total deals bob smith did in a given month.
Example. Column B is the column where the selling agent is listed. Bob Smith is listed as the agent in column B Cells B7, B8, B9, B12, B13, B21, B25. At the bottom of my sheet, I have a list of all agents including Bob smith, I want to be able to add up all Cells B7, B8, B9, B12, B13, B21, B25 and give me a total deal count for Bob smith.

I hope this makes sense. Sorry if this may have been a previous post, seems like a common question, however, I was unable to find any type of question or answer to this issue so I posted.