Avoid auto sorting in Google Sheets Query-CodePudding

I am facing the issue, that during a query I get auto sorting of the group of results. The code is following: =QUERY('Sheet1'!A1:H;"select A, sum(H) where A is not null group by A ";1)

I would like to keep the original order of elements and not want to get a sorted list.

I would appreciate any help in this topic.

Thank you in advance.

CodePudding user response：

An easier way is this. You can use Filter, Unique and Sumif.

={unique(filter(DB!A:A,DB!A:A<>"")),arrayformula(SUMIF(DB!A:A,unique(filter(DB!A:A,DB!A:A<>"")),DB!H:H))}

Ciao @Terio

In my video I learn how these functions are used with SUMIF. But it's in Italian