OR logic and CONTAINS in a query in Google Sheets

google-sheets google-query-language
Guillaume Hubert picture Guillaume Hubert · Jan 13, 2018 · Viewed 12.2k times · Source

I have a problem with an OR logic in a query. I'm trying to make a sum of a column (D), if:

• column A = cars/build-price/carselector.html

• column B = contains ateca or ibiza (the cell could be "get the ateca", "new ibiza xx", ...)

• column C = footer

First tried with a SUMIFS but didn't work:

=SUMIFS(C:C;A:A;"cars/build-price/carselector.html";B:B;{"ateca"; "ibiza"};D:D;"footer")

then tried with a QUERY, but I don't really know this language:

=SUM(QUERY(A:D;"Select C where A='cars/build-price/carselector.html' and D='footer' and (B='ateca' or B='ibiza')"))

Can't find how to fit the "contains" and the "or" logic.

Someone can help?

Answer

pnuts picture pnuts · Jan 13, 2018

A query could be:

=QUERY(A:D,"select sum(D) where A='cars/build-price/carselector.html' and C='footer' and (B contains 'ateca' or B contains 'ibiza')")

Related questions

Google SpreadSheet Query: Can I remove column header?

I'm doing this query at my google spreadsheet: =QUERY(H4:L35;"select sum(L) where H='First Week'"; -1) But it returns a little table with "sum" as header and result below it. What I want is just the result! …

Read More
Google spreadsheet "=QUERY" join() equivalent function?

This question is concerning joining two databases in Google spreadsheet using =QUERY function I have a table like so in range A1:C3 a d g b e h c f i I have another table c j m a …

Read More
Google Spreadsheets QUERY() to combine multiple sheets, same workbook

Goal: I'm using QUERY() in gSheets to combine data from multiple sheets in the same workbook. The data is an extract from GA broken down into small segments to prevent sampling. This means it has all the same fields, I'm …

Read More