No, these functions use an aggregation function (like SUM). If you don't use an aggregation function the value of the cell is the top left element of the array.

No, these functions use an aggregation function (like SUM). If you don't use an aggregation function the value of the cell is the top left element of the array. The parent suggests a cell which value is an array object, which can then be queried by another formula.