Reputation: 15
I know this is a super beginner thing, but this is my first time using google sheets and I cannot understand their built-in assistance for what I need.
I have 2 columns. I am needing to find the totals for each category.
Ex: Dogs = 6, Cats = 2
Please let me know where I went wrong in my formula.
Upvotes: 1
Views: 81
Reputation: 5325
try this:
={UNIQUE(A2:A9), ARRAYFORMULA(COUNTIF(A2:A9, UNIQUE(A2:A9)))}
Upvotes: 2