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