CountIf and SubTotal Help for filtered results

Good day
Pilfered some formulas from this board and the WWW but after a few very frustrating hours still no working solution. Excel 2010 windows 8

I am in need of a formula to count filtered results. On Sheet1 (Job Flow) the user enters data continually . The most important is the Date in column D some measurements in columns N,O & P that gives a result as a code, example s15020 or c3005 in column Q. A vlookup is then pulls up a price for the code.

On sheet two Column A There is a list of all the codes. I need a formula that will give a count in column B for the amount of codes that was entered in to the data base "sold" for a date filtered time period, be it a week, month or year. In other words the codes in ,column A sheet 2, should reflect the amount of units for the time filter on page1.

If tried the following formula but with not much success

Please Login or Register  to view this content.

Any help will be greatly appreciated

Harry

post an example workbook