Importing Data Using Direct Cell References You can import data from one Google Sheets file to another by specifying the source URL and the relevant cell references.

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