I am trying to use this formula but it’s not working. Do you hava an idea why?
QUERY(IMPORTRANGE(“IMPORTEDDATASHEET”;”06_20!M:AJ”);”SELECT SUM(Col17) WHERE Col1 = ‘Company Name’ AND Col23 <> ‘ ‘ label SUM(Col17) ””)
I want to filter by a specific company name in Col1 and filter out all empty cells in Col23 and then sum up col 17.
I also tried IS NOT NULL and != ‘ ‘ instead of <> ‘ ‘, it didn’t work either.
Go to Source