Adding names selected in a drop down list

I have an excel spreadsheet I created to calculate deals for a car dealership. Each of the Salesmen are listed in a drop down and each time a purchase is made the Salesman is listed.

What I want to do is create a factor that calculates how many times a certain Salesperson is selected. For example;

Mike Smith sold a car
Bill Jefferson sold a car
Mike Smith sold a car
Tammy White sold a car

I would like to find a way to automatically calculate each person on a separate page.

Mike Smith 2
Bill Jefferson 1
Tammy White 1

Check out the below formula, whether it works. Copy first formula and paste in the cell C1 and give ctrl + D.

Column A Column B Column C Column D
Mike Smith sold a car Mike Smith 2 =COUNTIF($A:$A,"*"&B1&"*")
Bill Jefferson sold a car Bill Jefferson 1 =COUNTIF($A:$A,"*"&B2&"*")
Mike Smith sold a car Tammy White 1 =COUNTIF($A:$A,"*"&B3&"*")
Tammy White sold a car

Formula.PNG

Checkout this screenshot

Very close. Thank you.

Here is my ultimate goal. I have tabs for different Agents and appointments they set. If thier appointment sells I use a drop down to select the Sales Person credited with the deal and the Source that brought the customer in. I'd like to have it tabulate how many deals each Sales Person closes for my department next to their name on my variables tab.

I will present screenshots below.

sales_zps9e2b3339.jpg

sales2_zpsc125d465.jpg

can you attach these two tabs in a spreadsheet and send me.

Also, please mention to which department you need details.

use the same countif formula next to the sales person name.

=COUNTIF(range[select the Sales Person column in the 1st screenshot],criteria[select the sales person name in the 2nd screenshot i.e., cell #A2])

Ok, I got it. Now another question. How do I add another column from a different page? IE; =COUNTIF(KAYLA!I4:I254,[FAITH A! + JOEL!, ETC] VARIABLES!A2)

Thanks a ton for the help!

If you want the total count of the same sales person in all the tabs (KAYLA + JOEL + RANDY etc) then use below formula

=COUNTIFS(KAYLA!I4:I254,VARIABLES!A2,FAITH A!I4:I254, VARIABLES!A2,JOEL!I4:I254,VARIABLES!A2)

Else if you want the counts for each sales person sales from each tab separately, then insert a column in variable tab and enter the first formula referring each tab i.e., Joel, randy etc

I ended up creating one for each tab / sheet and adding just the totals on the variables page. But it works! Thanks a ton for the help Sati!

Sorry, still a newbie. But I got it fixed. I'd be impressed if you could edit my picture lol! I know better for next time.