Help with Monthly Report

So I have a spread sheet with 13 worksheets.

Each worksheet is labelled a Month of the Year (Jan, Feb, Mar, ...), and the last is titled "report".

In the worksheet titled "Report" in cell "F3" there is a drop down box with all the months of the year.
When the user selects the month from the list, this will then populate the report below.

What i am trying to do is find everyone who has sold a TV in my shop within that month.
In Colum “M” of all the worksheets is what they have sold TV, HIFI, etc… and in Colum F are the names of the sales assistant.
So I have a list of all the names of staff and want to put a number next to their name with amount of the TV’s they have sold in the chosen month. So I need a formula to read down Colum M and put a 1 next to the name if he has sold a TV.

The following formula is what i need to edit but I can’t get my head round it:-

HTML Code: 

Any help with would be great?

Can you attach the workbook?

test data has been added for assitance

That's great thanks.

Next question then :D

I now have a list of all the sales assistance who have sold a TV, but I now need to list in assenting order of the names of the sales assistants who have sold the most TV's.

As I have over 100 staff I don't want a table of my staff names and then use the cell the name appears as the search criteria as staff comes and goes.

I don't want to list every staff member and then use their names as a seach criteira with countif.

My ideas is to have a formula that will list that will the name that apears the most and then 2nd and 3rd and so on down to 15. Then I can use the result to count how many times it apears if that makes sense.

I don't think what I am after is possible so I have a work around.

I Have used a formula to return on the filtered names from the list. I then use the next column to remove the duplicates. The next column searches on the remaining entries and displays how many times it appears on list. I will then give it a rank using another formula. And then use vlookup to then sort the list on my report in order :D thanks for all the help who.

I'm now after a formula that will count to total entries that meet a certain criteria.

Managers name, date & What was sold.

something like this:

=COUNTIFS(range of data,"Managers Name", range of data,"date", range of data,"What was sold")

example: =COUNTIFS(Report!$C$3&F:F,=Dave,Report!$C$3&A:A,=24/10/2014, Report!$C$3&H:H,=TV)

I get an error with the above formula. Any help would be great.

I want sample datasheet for sales, customer & order processing spreadsheet which should be simple to operate and should have detailed information. Please help me out !