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 |
microsoft | 1 |
How do I count the total values attributed to each, unique label in Column A with a formula? (I have over 3,000 labels in my spreadsheet and cannot count each label individually).
Thanks,
Catriona
I'd create a pivot table based on the data.
Add Brand to the Rows area and Clicks to the Values area.
3 Replies
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)I'd create a pivot table based on the data.
Add Brand to the Rows area and Clicks to the Values area.
Super easy! Thanks!
