How to use Query functions to count values from rows?

Question

I would like to ask help to use Query functions to count values from rows? I knew how to use =COUNTA() function to generate same results. Since my data is huge, I prefer to use Query function to keep my data flexible. Thank you for helping.

https://docs.google.com/spreadsheets/d/1dYrf4b1G7UouSY4XczqAClK3PhFWUkMVHJDftBRS65c/edit?usp=sharing

player0 · Answer

try:

=INDEX(QUERY(FLATTEN(IF(B2:F10="",,A2:A10)), 
 "select Col1,count(Col1) where Col1 is not null group by Col1 label count(Col1)''"))

How to use Query functions to count values from rows?

1 Answers