The aggregation functions you can use in a QUERY formula are avg (), count (), max (), min (), and sum (). The clause types ...

QUERY QUERY brings database-style searching to Google Sheets using SQL-like language. While it might sound intimidating initially, this Google Sheets function can save you hours every week.