Forum Discussion
Solved
Count Total Values for Each Label
Hi, Column A has duplicate labels and Column B has a value attributing to each label in Column A. Brand Clicks redwood 11 yahoo 12 twitty 1 yahoo 8 ...
I'd create a pivot table based on the data.
Add Brand to the Rows area and Clicks to the Values area.
With a formula and access to Excel 365 you can use:
=LET(
UniqueBrands, SORT(UNIQUE(brand)),
totals, SUMIF(brand, UniqueBrands, clicks),
HSTACK(UniqueBrands, totals)
)
Within a year or so (once GROUPBY is available), it gets simpler:
=GROUPBY(brand,clicks,SUM)