Wikifunctions:Google Sheets functions
Google Sheets functions include the following.[1]
| Type | Name | Syntax | Description |
|---|---|---|---|
| Array | ARRAY_CONSTRAIN |
ARRAY_CONSTRAIN(input_range, num_rows, num_cols) | Constrains an array result to a specified size. Learn more |
BYCOL |
BYCOL(array_or_range, LAMBDA) | Groups an array by columns by application of a LAMBDA function to each column. Learn more | |
BYROW |
BYROW(array_or_range, LAMBDA) | Groups an array by rows by application of a LAMBDA function to each row. Learn more | |
CHOOSECOLS |
CHOOSECOLS(array, col_num1, [col_num2]) | Creates a new array from the selected columns in the existing range. Learn more | |
CHOOSEROWS |
CHOOSEROWS(array, row_num1, [row_num2]) | Creates a new array from the selected rows in the existing range. Learn more | |
FLATTEN |
FLATTEN(range1,[range2,...]) | Flattens all the values from one or more ranges into a single column. Learn more | |
FREQUENCY |
FREQUENCY(data, classes) | Calculates the frequency distribution of a one-column array into specified classes. Learn more | |
GROWTH |
GROWTH(known_data_y, [known_data_x], [new_data_x], [b]) | Given partial data about an exponential growth trend, fits an ideal exponential growth trend and/or predicts further values. Learn more | |
HSTACK |
HSTACK(range1; [range2, …]) | Appends ranges horizontally and in sequence to return a larger array. Learn more | |
LINEST |
LINEST(known_data_y, [known_data_x], [calculate_b], [verbose]) | Given partial data about a linear trend, calculates various parameters about the ideal linear trend using the least-squares method. Learn more | |
LOGEST |
LOGEST(known_data_y, [known_data_x], [b], [verbose]) | Given partial data about an exponential growth curve, calculates various parameters about the best fit ideal exponential growth curve. Learn more | |
MAKEARRAY |
MAKEARRAY(rows, columns, LAMBDA) | Returns an array of specified dimensions with values calculated by application of a LAMBDA function. Learn more | |
MAP |
MAP(array1, [array2, ...], LAMBDA) | Maps each value in the given arrays to a new value by application of a LAMBDA function to each value. Learn more | |
MDETERM |
MDETERM(square_matrix) | Returns the matrix determinant of a square matrix specified as an array or range. Learn more | |
MINVERSE |
MINVERSE(square_matrix) | Returns the multiplicative inverse of a square matrix specified as an array or range. Learn more | |
MMULT |
MMULT(matrix1, matrix2) | Calculates the matrix product of two matrices specified as arrays or ranges. Learn more | |
REDUCE |
REDUCE(initial_value, array_or_range, LAMBDA) | Reduces an array to an accumulated result by application of a LAMBDA function to each value. Learn more | |
SCAN |
SCAN(initial_value, array_or_range, LAMBDA) | 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. Learn more | |
SUMPRODUCT |
SUMPRODUCT(array1, [array2, ...]) | Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges. Learn more | |
SUMX2MY2 |
SUMX2MY2(array_x, array_y) | Calculates the sum of the differences of the squares of values in two arrays. Learn more | |
SUMX2PY2 |
SUMX2PY2(array_x, array_y) | Calculates the sum of the sums of the squares of values in two arrays. Learn more | |
SUMXMY2 |
SUMXMY2(array_x, array_y) | Calculates the sum of the squares of differences of values in two arrays. Learn more | |
TOCOL |
TOCOL(array_or_range, [ignore], [scan_by_column]) | Transforms an array or range of cells into a single column. Learn more | |
TOROW |
TOROW(array_or_range, [ignore], [scan_by_column]) | Transforms an array or range of cells into a single row. Learn more | |
TRANSPOSE |
TRANSPOSE(array_or_range) | Transposes the rows and columns of an array or range of cells. Learn more | |
TREND |
TREND(known_data_y, [known_data_x], [new_data_x], [b]) | Given partial data about a linear trend, fits an ideal linear trend using the least squares method and/or predicts further values. Learn more | |
VSTACK |
VSTACK(range1; [range2, …]) | Appends ranges vertically and in sequence to return a larger array. Learn more | |
WRAPCOLS |
WRAPCOLS(range, wrap_count, [pad_with]) | Wraps the provided row or column of cells by columns after a specified number of elements to form a new array. Learn more | |
WRAPROWS |
WRAPROWS(range, wrap_count, [pad_with]) | Wraps the provided row or column of cells by rows after a specified number of elements to form a new array. Learn more | |
| Database |