counting instances by unique product code

%3CLINGO-SUB%20id%3D%22lingo-sub-2886211%22%20slang%3D%22en-US%22%3Ecounting%20instances%20by%20unique%20product%20code%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2886211%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3Bfor%20the%20sample%20file%20i%20have%20attached%20i%20want%20to%20count%20when%20the%20term%20%22negative%22%20is%20used%20in%20sheet%201%20-%20column%20M%20and%20have%20this%20counted%20and%20automatically%20summed%20in%20sheet%202%20for%20each%20unique%20product%20code%20-%20column%20F.%20I%20couldn't%20get%20the%20formula%20to%20work%20when%20i%20was%20used%20and%20if%20formula%20earlier.%20Thanks%2C%20Kind%20Regards%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2886211%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2886272%22%20slang%3D%22en-US%22%3ERe%3A%20counting%20instances%20by%20unique%20product%20code%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2886272%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F960851%22%20target%3D%22_blank%22%3E%40cmckernan93%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DCOUNTIFS(Sheet1!%24C%242%3A%24C%246%2CSheet2!A2%2CSheet1!%24M%242%3A%24M%246%2C%22Negative%22)%3C%2FP%3E%3CP%3EIs%20this%20the%20formula%20you%20are%20looking%20for%3F%20I%20entered%20formula%20in%20F2%20and%20copied%20down%20to%20F4%20in%20Sheet2.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2886350%22%20slang%3D%22en-US%22%3ERe%3A%20counting%20instances%20by%20unique%20product%20code%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2886350%22%20slang%3D%22en-US%22%3Ethat%20should%20work%2C%20can%20you%20talk%20me%20through%20how%20you%20got%20it%20please%3F%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello,

 

 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

@cmckernan93 

=COUNTIFS(Sheet1!$C$2:$C$6,Sheet2!A2,Sheet1!$M$2:$M$6,"Negative")

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?