# Tutorial - QUERY: "The most powerful function" in Google Sheets (part 1) **URL:** \ **Category:** Ask for Help\ **Created:** [June 7, 2020, 9:16am UTC](https://community.glideapps.com/t/tutorial-query-the-most-powerful-function-in-google-sheets-part-1/10432 "2020-06-07T09:16:34Z")\ **Posts on this page:** 1\ **Showing post:** 6
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 7, 2020, 12:37pm UTC](https://community.glideapps.com/t/tutorial-query-the-most-powerful-function-in-google-sheets-part-1/10432/6 "2020-06-07T12:37:02Z")
I would imagine mostly data cleaning, but for some complex cases, for example this: > [@Multiple criteria sumif array formula with logic](https://community.glideapps.com/t/multiple-criteria-sumif-array-formula-with-logic/9155/3): > > 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. --- _[View the full topic](https://community.glideapps.com/t/tutorial-query-the-most-powerful-function-in-google-sheets-part-1/10432)._