CODEWITHSUNDEEP
arraysgoogle-sheetsgoogle-sheets-formulacountinggoogle-sheets-query
John Doe
John Doe

Reputation: 11

Count of current values in column

I'd like to know count of current value in column.

+--------------+---------------------+--+------------+------------+
|              |                     |  | 1st column | 2nd column |
+--------------+---------------------+--+------------+------------+
| How many 'A' | (there should be 1) |  | A          | B          |
+--------------+---------------------+--+------------+------------+
| How many 'B' | (there should be 2) |  | B          | B          |
+--------------+---------------------+--+------------+------------+
|              |                     |  | B          | A          |
+--------------+---------------------+--+------------+------------+

I try to do this in Google Sheets.

Upvotes: 1

Views: 51

Answers (1)

player0
player0

Reputation: 1

try:

=QUERY({D2:D; E2:E}, 
 "select Col1,count(Col1) 
  where Col1 is not null 
  group by Col1 
  label count(Col1)''", 0)

Upvotes: 1

Related Questions