For instance, if a cell in one worksheet has a sales number, you can display that value in another worksheet by adding a reference to that cell.

Add the target sheet name before the cell reference in the table array, separated by an exclamation mark. This makes the VLookup formula reference the cell range on another sheet.

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