Google Sheets array functions
Array functions in Google Sheets, explained with live examples.
29 array functions in Google Sheets — 1 documented in depth so far, the rest indexed below and landing every week.
Documented array functions
Syntax, examples, and the equivalent — ready now.
All Google Sheets array functions
The full set — deep dives on the way.
- ARRAY_CONSTRAIN
- Constrains an array result to a specified size.
- BYCOL
- Groups an array by columns by application of a LAMBDA function to each column.
- BYROW
- Groups an array by rows by application of a LAMBDA function to each row.
- CHOOSECOLS
- Creates a new array from the selected columns in the existing range.
- CHOOSEROWS
- Creates a new array from the selected rows in the existing range.
- FLATTEN
- Flattens all the values from one or more ranges into a single column.
- FREQUENCY
- Calculates the frequency distribution of a one-column array into specified classes.
- GROWTH
- Given partial data about an exponential growth trend, fits an ideal exponential growth trend and/or predicts further values.
- HSTACK
- Appends ranges horizontally and in sequence to return a larger array.
- LOGEST
- Given partial data about an exponential growth curve, calculates various parameters about the best fit ideal exponential growth curve.
- MAKEARRAY
- Returns an array of specified dimensions with values calculated by application of a LAMBDA function.
- MAP
- Maps each value in the given arrays to a new value by application of a LAMBDA function to each value.
- MDETERM
- Returns the matrix determinant of a square matrix specified as an array or range.
- MINVERSE
- Returns the multiplicative inverse of a square matrix specified as an array or range.
- MMULT
- Calculates the matrix product of two matrices specified as arrays or ranges.
- REDUCE
- Reduces an array to an accumulated result by application of a LAMBDA function to each value.
- SCAN
- Scans an array and produces intermediate values by application of a LAMBDA function to each value. Returns an array of the intermediate values obtained at each step.
- SUMPRODUCT
- Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.
- SUMX2MY2
- Calculates the sum of the differences of the squares of values in two arrays.
- SUMX2PY2
- Calculates the sum of the sums of the squares of values in two arrays.
- SUMXMY2
- Calculates the sum of the squares of differences of values in two arrays.
- TOCOL
- Transforms an array or range of cells into a single column.
- TOROW
- Transforms an array or range of cells into a single row.
- TRANSPOSE
- Transposes the rows and columns of an array or range of cells.
- TREND
- Given partial data about a linear trend, fits an ideal linear trend using the least squares method and/or predicts further values.
- VSTACK
- Appends ranges vertically and in sequence to return a larger array.
- WRAPCOLS
- Wraps the provided row or column of cells by columns after a specified number of elements to form a new array.
- WRAPROWS
- Wraps the provided row or column of cells by rows after a specified number of elements to form a new array.
More Google Sheets function categories