Jump to content

Wikifunctions:Google Sheets functions

From Wikifunctions

Google Sheets functions include the following.[1]

Overview Google Sheets functions
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

References

  1. Template:Cite web