How to Query this formula and it's possible to add automatically sort fucntion?

Viewed 29

I'm using this formula below but only show 2 column can I add like 6 - 8 column? and adding more function like sort from A-Z like 0-9 something?

=query(ArrayFormula({{unique(text('RAW'!M:M,"0"))}, {sumif(text('RAW'!M:M,"0"), unique(text('RAW'!M:M,"0")),'RAW'!AV:AV)}}),"Select * where Col2>0")

0 Answers
Related