Google-sheets – Query Importrange with multiple values

formulasgoogle sheetsgoogle-sheets-queryimportrange

This formula is working fine, but I need to add in other teams into Column A. I would need to return ATT SLC, ATT Orem, and ATT Scottsdale within this same range, but I'm not sure the language to use to extend the return values

Hopefully the image is readable, if not here is the query I'm working on

=query(importrange("Google Doc URL","Total Summary!A:K"),"where Col1='ATT SLC'")

Again I think it would go something like this, ("Where Col1='ATT SLC','ATT Orem' etc) to get more than one team on a single import.

Best Answer

=QUERY(IMPORTRANGE("key/url", "Total Summary!A:K"), "where Col1='ATT SLC' 
                                                        or Col1='ATT Orem' 
                                                        or Col1='ATT Scottsdale'")

Related Solutions

Google Sheets – How to Use IMPORTRANGE with a Variable Range-String

If your referring to the cell where the regular text is you don't need to add the additional "" around the ="""2016 Data!"&B41&"2:"&B41&"13"""

just simply enter: ="2016 Data!"&B41&"2:"&B41&"13"

You only add the additional quotes when your directly entering that data into the formula, not when its via the cell reference

Google Sheets Query – Group by Multiple Columns

Replace and by ,.

Final formula:

=QUERY(ARRAYFORMULA(IMPORTRANGE(
"https://docs.google.com/spreadsheets/d/1Wyewpz0j_IiKK8ESOapX5L4AedjvHccLZOOKS2tZGUA/",
"UsuallyAnotherSpreadsheetFile!B2:K")),"Select Col4, Col3, sum(Col8), sum(Col9) 
where (Col1 = '" & ClientInfo!$H$1 & "') group by Col4, Col3 label sum(Col8) '',
sum(Col9) ''")

Best Answer

Related Solutions

Google Sheets – How to Use IMPORTRANGE with a Variable Range-String

Google Sheets Query – Group by Multiple Columns

Related Topic