Hi, I have a list of Brands and within those brands I have different labels. I am trying to work out how many different labels are within in each brand. The brands are in column A and the labels in column B. I concatenated column A and B into column C. I put the first formula in D2 which is =COUNTIF($C$2:C2,C2). The second formula is in E2 which is =SUMIFS($D$2:$D$15,$D$2:$D$15,"=1",$A$2:$A$15,A2). The formulas work but I was wondering can I combine the 2 formulas into 1 without having to concatenate. I have been trying but without success. Hope someone can help me.
Bookmarks