The aggregation functions you can use in a QUERY formula are avg (), count (), max (), min (), and sum (). The clause types are select, where, group by, pivot, order by, limit, offset, label, format, ...

Importing data into Excel from other sources can result in long, messy strings of text you need to parse. We'll show you how.