Help Categorizing Data

%3CLINGO-SUB%20id%3D%22lingo-sub-1897071%22%20slang%3D%22en-US%22%3EHelp%20Categorizing%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1897071%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%20I'm%20sure%20that%20I%20have%20the%20verbiage%20wrong%20but%20I%20need%20help%20figuring%20out%20how%20to%20categorize%20some%20data.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20attached%20some%20samples%20below.%20I%20fill%20out%20a%20weekly%20report%20that%20tracks%20how%20often%20products%20are%20featured%20in%20advertisements.%26nbsp%3B%20The%20products%20are%20supplied%20by%20two%20different%20brands.%20Brand%20A%20and%20B.%20Is%20there%20a%20way%20for%20when%20I%20track%20the%20ad%20appearances%20that%20they%20can%20auto%20categorize%20themselves%20into%20each%20company%20category.%20In%20line%205%20and%206%20I%20track%20the%20total%20items%20in%20ad%20by%20distributor.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20there%20is%20a%20way%20to%20do%20this%2C%20but%20I%20can't%20remember!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1897071%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1897398%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20Categorizing%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1897398%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F872184%22%20target%3D%22_blank%22%3E%40nmbalmforth%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDepends%20on%20which%20calculation%20you'd%20like%20to%20do.%20For%20example%2C%20count%20number%20of%20Brand%20A%20products%20in%20weekly%20report%20is%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DSUM(COUNTIF(BrandA%20list%2Cweekly%20list))%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello! I'm sure that I have the verbiage wrong but I need help figuring out how to categorize some data. 

 

I've attached some samples below. I fill out a weekly report that tracks how often products are featured in advertisements.  The products are supplied by two different brands. Brand A and B. Is there a way for when I track the ad appearances that they can auto categorize themselves into each company category. In line 5 and 6 I track the total items in ad by distributor. 

 

I know there is a way to do this, but I can't remember!

 

Thank you! 

 

 

3 Replies
Highlighted

@nmbalmforth 

Depends on which calculation you'd like to do. For example, count number of Brand A products in weekly report is like

=SUM(COUNTIF(BrandA list,weekly list))
Highlighted

@Sergei Baklan  Thank you for the help! 

 

When I try this I keep getting a zero for the total. Any suggestions?

 

Thank you!

Highlighted

@nmbalmforth 

You may try SUMPRODUCT

image.png