ARRAY_CONSTRAIN
ARRAY_CONSTRAIN(input_range, num_rows, num_cols)
Constrains an array result to a specified size. Learn more
Apri schedaFunzioni Google Sheets
Una scheda strutturata per ogni funzione: sintassi, argomenti, esempi pratici, errori comuni, FAQ e collegamenti a formule correlate.
Digita almeno 2 lettere per vedere i suggerimenti.
BYCOL
BYCOL(array_or_range, LAMBDA)
Groups an array by columns by application of a LAMBDA function to each column. Learn more
Apri schedaBYROW
BYROW(array_or_range, LAMBDA)
Groups an array by rows by application of a LAMBDA function to each row. Learn more
Apri schedaCHOOSECOLS
CHOOSECOLS(array, col_num1, [col_num2])
Creates a new array from the selected columns in the existing range. Learn more
Apri schedaCHOOSEROWS
CHOOSEROWS(array, row_num1, [row_num2])
Creates a new array from the selected rows in the existing range. Learn more
Apri schedaFLATTEN
FLATTEN(range1,[range2,...])
Flattens all the values from one or more ranges into a single column. Learn more
Apri schedaFREQUENCY
FREQUENCY(data, classes)
Calculates the frequency distribution of a one-column array into specified classes. Learn more
Apri schedaGROWTH
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
Apri schedaHSTACK
HSTACK(range1; [range2, …])
Appends ranges horizontally and in sequence to return a larger array. Learn more
Apri schedaLINEST
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
Apri schedaLOGEST
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
Apri schedaMAKEARRAY
MAKEARRAY(rows, columns, LAMBDA)
Returns an array of specified dimensions with values calculated by application of a LAMBDA function. Learn more
Apri schedaMAP
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
Apri schedaMDETERM
MDETERM(square_matrix)
Returns the matrix determinant of a square matrix specified as an array or range. Learn more
Apri schedaMINVERSE
MINVERSE(square_matrix)
Returns the multiplicative inverse of a square matrix specified as an array or range. Learn more
Apri schedaMMULT
MMULT(matrix1, matrix2)
Calculates the matrix product of two matrices specified as arrays or ranges. Learn more
Apri schedaREDUCE
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
Apri schedaSCAN
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
Apri schedaSUMPRODUCT
SUMPRODUCT(array1, [array2, ...])
Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges. Learn more
Apri schedaSUMX2MY2
SUMX2MY2(array_x, array_y)
Calculates the sum of the differences of the squares of values in two arrays. Learn more
Apri schedaSUMX2PY2
SUMX2PY2(array_x, array_y)
Calculates the sum of the sums of the squares of values in two arrays. Learn more
Apri schedaSUMXMY2
SUMXMY2(array_x, array_y)
Calculates the sum of the squares of differences of values in two arrays. Learn more
Apri schedaTOCOL
TOCOL(array_or_range, [ignore], [scan_by_column])
Transforms an array or range of cells into a single column. Learn more
Apri schedaTOROW
TOROW(array_or_range, [ignore], [scan_by_column])
Transforms an array or range of cells into a single row. Learn more
Apri schedaTRANSPOSE
TRANSPOSE(array_or_range)
Transposes the rows and columns of an array or range of cells. Learn more
Apri schedaTREND
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
Apri schedaVSTACK
VSTACK(range1; [range2, …])
Appends ranges vertically and in sequence to return a larger array. Learn more
Apri schedaWRAPCOLS
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
Apri schedaWRAPROWS
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
Apri scheda