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:-
Any help with would be great?HTML Code:
Bookmarks