|
QUERY function Runs a Google Visualisation API Query Language query across data. Sample usage QUERY(A2:E6 'select avg(A) pivot B') QUERY(A2:E6 F2 FALSE) Syntax QUERY(data query [headers]) data ? The range of cells to perform the query on. Each column of data can only hold boolean numeric (including date/time types) or string values.
https://support.google.com/docs/answer/3093343?hl=en-GB
|