counting instances by unique product code

Occasional Contributor



 for the sample file i have attached i want to count when the term "negative" is used in sheet 1 - column M and have this counted and automatically summed in sheet 2 for each unique product code - column F. I couldn't get the formula to work when i was used and if formula earlier. Thanks, Kind Regards 

2 Replies



Is this the formula you are looking for? I entered formula in F2 and copied down to F4 in Sheet2.

that should work, can you talk me through how you got it please?