1

I am looking to pull multiple counts into a mini-chart from a column with multiple values. I am trying to do it with one formula. It would end up looking something like this:

ZIP codes Count
11238 4
46260 2
30201 1

Is there any way to make this with one formula? Thanks for the help!

Matt B.
  • 331
  • 3
  • 12

1 Answers1

0

To be complete, you can use the count() operator and group by predicate in your QUERY statement to count occurrences of a column.

Sample:

Using =QUERY(A1:B6,"select A,count(B) group by A",1)

enter image description here

References:

QUERY()

Query Language Reference

CMB
  • 4,950
  • 1
  • 4
  • 16