Apple's Numbers spreadsheet for Mac, iPhone, and iPad, is not as powerful as Microsoft Excel, but most users will be hard-pressed to find its limitations — and will immediately see how much easier ...

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