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 Col17
.
I also tried IS NOT NULL
and != ' '
instead of <> ' '
, it didn't work either.