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

You can use SUMIF in Google Sheets to add numbers together that are associated with a date range, specific text, or meet a numeric criterion.

Learn how to use Gemini in Google Sheets for basic and advanced tasks like creating tables, generating formulas, cleaning data, and summarizing information efficiently.