How do I select multiple different counts with different where clauses in Google Sheets query language?

Question

I'm currently trying to select multiple counts with different criteria. Unfortunately, I am getting a PARSE error when I try to combine them into the same query. They work fine individually, just not together. Anyone know how to fix this?

This works fine (separately)

Select count(Col2) where Col2 <= 180 

or 

Select count(Col2) where Col2 > 180

or

Select count(Col2)

This doesn't work (combined)

Select count(Col2) where Col2 <= 180, count(Col2) where Col2 > 180, count(Col2)

Error that I get when I try

Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered

player0 · Accepted Answer · 2024-05-13 20:42:37Z

0

you must use only one where

"select count(Col2) where Col2 <= 180 or Col2 > 180"

OR logic can be exchanged with AND logic if/when needed

try:

=INDEX(LET(a, A:B, {
 QUERY(a, "select count(Col2) where Col2 <= 180"), 
 QUERY(a, "select count(Col2) where Col2 > 180"), 
 QUERY(a, "select count(Col2)")}))

edited May 13, 2024 at 20:42

answered May 13, 2024 at 20:37

player0

131k14 gold badges91 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

AlanSTACK Over a year ago

Possible to have multiple WHERE clauses in the same statement? 🤔 I need separate counts for statistical analysis.

player0 Over a year ago

@AlanSTACK only once per statement. see: developers.google.com/chart/interactive/docs/…

AlanSTACK Over a year ago

Ah, I was trying to avoid multiple statements because of the aforementioned network calls. Looks like that isn't possible. Oh well.

Collectives™ on Stack Overflow

How do I select multiple different counts with different where clauses in Google Sheets query language?

This works fine (separately)

This doesn't work (combined)

Error that I get when I try

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

This works fine (separately)

This doesn't work (combined)

Error that I get when I try

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related