Tutorial - QUERY: "The most powerful function" in Google Sheets (part 1)

[ThinhDinh]

I would imagine mostly data cleaning, but for some complex cases, for example this:

Multiple criteria sumif array formula with logic

Ok I’m back with what seems to work. Firstly, ArrayFormula does not work with SUMIFS, or QUERY. It would have been such easier tasks had it been that way. I have worked with many people who want to implement ARRAYFORMULA into their work so that automatic calculation can be applied whenever there’s a new row. Recently I faced the same problem when working on a logic with @Robert_Petitto and wrote a little script as a workaround, I will have a single post for this later so it can be used as a re…

If the person wants to have a quick solution for their problem then QUERY can be used, before we can think of a solution in Glide editor. That’s the first cause for this. Secondly, I believe this would help people in their normal work as well.

Of course I want to do all things in the Glide editor myself to eliminate the lagging, and Glide editor is getting stronger by time.