Google Sheets array functions
Array functions in Google Sheets, explained with live examples.
29 array functions in Google Sheets — 23 documented in depth so far, the rest indexed below and landing every week.
Documented array functions
Syntax, examples, and the equivalent — ready now.
- BYCOLGroups an array by columns by application of a LAMBDA function to each column.ArrayExcel
- BYROWGroups an array by rows by application of a LAMBDA function to each row.ArrayExcel
- CHOOSECOLSCreates a new array from the selected columns in the existing range.ArrayExcel
- CHOOSEROWSCreates a new array from the selected rows in the existing range.ArrayExcel
- HSTACKAppends ranges horizontally and in sequence to return a larger array.ArrayExcel
- LINESTGiven partial data about a linear trend, calculates various parameters about the ideal linear trend using the least-squares method.ArrayExcel
- MAKEARRAYReturns an array of specified dimensions with values calculated by application of a LAMBDA function.ArrayExcel
- MAPMaps each value in the given arrays to a new value by application of a LAMBDA function to each value.ArrayExcel
- MDETERMReturns the matrix determinant of a square matrix specified as an array or range.ArrayExcel
- MINVERSEReturns the multiplicative inverse of a square matrix specified as an array or range.ArrayExcel
- MMULTCalculates the matrix product of two matrices specified as arrays or ranges.ArrayExcel
- REDUCEReduces an array to an accumulated result by application of a LAMBDA function to each value.ArrayExcel
- SCANScans 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.ArrayExcel
- SUMPRODUCTCalculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.ArrayExcel
- SUMX2MY2Calculates the sum of the differences of the squares of values in two arrays.ArrayExcel
- SUMX2PY2Calculates the sum of the sums of the squares of values in two arrays.ArrayExcel
- SUMXMY2Calculates the sum of the squares of differences of values in two arrays.ArrayExcel
- TOCOLTransforms an array or range of cells into a single column.ArrayExcel
- TOROWTransforms an array or range of cells into a single row.ArrayExcel
- TRANSPOSETransposes the rows and columns of an array or range of cells.ArrayExcel
- VSTACKAppends ranges vertically and in sequence to return a larger array.ArrayExcel
- WRAPCOLSWraps the provided row or column of cells by columns after a specified number of elements to form a new array.ArrayExcel
- WRAPROWSWraps the provided row or column of cells by rows after a specified number of elements to form a new array.ArrayExcel
All Google Sheets array functions
The full set — deep dives on the way.
- ARRAY_CONSTRAIN
- Constrains an array result to a specified size.
- 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.
- LOGEST
- Given partial data about an exponential growth curve, calculates various parameters about the best fit ideal exponential growth curve.
- TREND
- Given partial data about a linear trend, fits an ideal linear trend using the least squares method and/or predicts further values.
More Google Sheets function categories