SOLVED

# Count Total Values for Each Label

Copper Contributor

# 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

3 Replies
best response confirmed by cat36290 (Copper Contributor)
Solution

# Re: Count Total Values for Each Label

I'd create a pivot table  based on the data.

Add Brand to the Rows area and Clicks to the Values area.

# Re: Count Total Values for Each Label

``````=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)``

# Re: Count Total Values for Each Label

Super easy! Thanks!

1 best response

Accepted Solutions
best response confirmed by cat36290 (Copper Contributor)
Solution

# Re: Count Total Values for Each Label

I'd create a pivot table  based on the data.

Add Brand to the Rows area and Clicks to the Values area.