google-sheetsimportsumvlookupgoogle-query-language
Filter and Importrange not accepting multiple criteria in Google Sheets
I'm trying to use this formula but the last IMPORTRANGE criteria is not working:
Formula:
=IFNA(filter(SUMIFS(IMPORTRANGE("URL","GA_Base!C:C"),IMPORTRANGE("URL","GA_Base!A:A")=H77), IMPORTRANGE("URL","GA_Base!B:B")="DP"))
This is the criteria that is not working:
IMPORTRANGE("URL","GA_Base!B:B")="DP"
Am I doing something wrong because it's multiple criteria?
Solution
try:
=INDEX(IFNA(VLOOKUP(E6:E36, QUERY(
IMPORTRANGE("1qsdPwnYRbmj5oW5f2QOwLfsPAloLsAHnoJWdF9cQELg", "Base!A:C"),
"select Col1,sum(Col3) where Col2 = 'DP' group by Col1"), 2, 0)))
- Split If not certain word and not first 4 characters
- How to Import XML table Google Sheets
- Match data based on id between sheets of one googlesheet having huge data?
- Calculating derived values
- Is there any way to do a bitwise shift right on a very large number in Google Sheets?
- Reset Column and Row sizes to default
- How to filter filter data after extracted data in Json form
- can i somehow determine which clickable image on my sheet is pressed rn
- Is there a way to copy from a Google Sheets that is copy locked?
- Query for normalized Google Sheet table
- Sum the continuity in columns of Google sheet
- Count rows with not empty value
- how to import data from one google sheet to another google sheet without appscript
- How to wait for an HTTPrequest response
- Creating Nested List with Google Sheet Formulas from Pre-Made Tables (on 3 levels)
- Try construct dynamic cell reference from a google sheet in google app script for CopyTo method
- Google Apps Script BatchUpdate appending single apostrophe to output
- How to calculate value based on tax bracket using Google sheet formula?
- Google script to dynamically addressing a cell in google sheet
- Add 95 to a cell if the name and date in that row match another row with the same name and date
- Auto numbering rows in GoogleSheet
- Error message while automating data entry from web app contact form to google sheet
- How do I send email to user by appending my domain name to the user name in Google Apps Script?
- How to split comma-separated values across multiple rows dynamically?
- Replace multiple strings in Google Spreadsheet with script
- How to count the amount of times a substring appears in a range of cells?
- Query with multiple data types
- Count If Range Matches Lookup in another tab
- Google Sheets Query where data in either of two columns matches the value in a cell populated by a multi-select dropdown
- Trying to combine words and math in a single cell in google sheets