Counting Number Of passes & fails by date + product

Hi,

Have to create a sumif/countif function wherein all passes/fails for a product code AND date need to be tallied.

eg. is attached....how will I do it....say X product had 4 passes on 1st JAN and 1 Fail (Put as P and F by user)....want to summarize and count it ..Need to use both the date and product code to match so that there are no errors in calculations....

Attached excel sheet.

Sorry I can't help you, but have the same query - I have a worksheet with Sales Manager, CPD Type and CPD Scores, I have to find the average score for each CPD Type for each Sales Manager, and it's too many arguments for all the functions I've tried.

I think a PivotTable / PivotChart would do this, but I've not worked those out yet