DAVERAGE
DAVERAGE(database, field, criteria)
Returns the average of a set of values selected from a database table-like array or range using a SQL-like query. Learn more
Analisi dati
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.
272 formule trovate · pagina 1 di 6
Non sai da dove partire?
Percorsi per livello e use case
Base
Intermedio
Avanzato
Use case
Sfida del giorno
DCOUNT
DCOUNT(database, field, criteria)
Counts numeric values selected from a database table-like array or range using a SQL-like query. Learn more
Analisi dati
Apri schedaDCOUNTA
DCOUNTA(database, field, criteria)
Counts values, including text, selected from a database table-like array or range using a SQL-like query. Learn more
Analisi dati
Apri schedaDGET
DGET(database, field, criteria)
Returns a single value from a database table-like array or range using a SQL-like query. Learn more
Analisi dati
Apri schedaDMAX
DMAX(database, field, criteria)
Returns the maximum value selected from a database table-like array or range using a SQL-like query. Learn more
Analisi dati
Apri schedaDMIN
DMIN(database, field, criteria)
Returns the minimum value selected from a database table-like array or range using a SQL-like query. Learn more
Analisi dati
Apri schedaDPRODUCT
DPRODUCT(database, field, criteria)
Returns the product of values selected from a database table-like array or range using a SQL-like query. Learn more
Analisi dati
Apri schedaDSTDEV
DSTDEV(database, field, criteria)
Returns the standard deviation of a population sample selected from a database table-like array or range using a SQL-like query. Learn more
Analisi dati
Apri schedaDSTDEVP
DSTDEVP(database, field, criteria)
Returns the standard deviation of an entire population selected from a database table-like array or range using a SQL-like query. Learn more
Analisi dati
Apri schedaDSUM
DSUM(database, field, criteria)
Returns the sum of values selected from a database table-like array or range using a SQL-like query. Learn more
Analisi dati
Apri schedaDVAR
DVAR(database, field, criteria)
Returns the variance of a population sample selected from a database table-like array or range using a SQL-like query. Learn more
Analisi dati
Apri schedaDVARP
DVARP(database, field, criteria)
Returns the variance of an entire population selected from a database table-like array or range using a SQL-like query. Learn more
Analisi dati
Apri schedaFILTER
FILTER(range, condition1, [condition2])
Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions. Learn more
Analisi dati Marketing Automazione
Apri schedaSORT
SORT(range, sort_column, is_ascending, [sort_column2], [is_ascending2])
Sorts the rows of a given array or range by the values in one or more columns. Learn more
Analisi dati
Apri schedaSORTN
SORTN(range, [n], [display_ties_mode], [sort_column1, is_ascending1], ...)
Returns the first n items in a data set after performing a sort. Learn more
Analisi dati
Apri schedaQUERY
QUERY(data, query, [headers])
Runs a Google Visualization API Query Language query across data. Learn more
Automazione Marketing Analisi dati
Apri schedaCELL
CELL(info_type, reference)
Returns the requested information about the specified cell. Learn more
Analisi dati
Apri schedaERROR.TYPE
ERROR.TYPE(reference)
Returns a number corresponding to the error value in a different cell. Learn more
Analisi dati
Apri schedaISBLANK
ISBLANK(value)
Checks whether the referenced cell is empty. Learn more
Analisi dati
Apri schedaISDATE
ISDATE(value)
Returns whether a value is a date. Learn more.
Analisi dati
Apri schedaISEMAIL
ISEMAIL(value)
Checks whether a value is a valid email address. Learn more
Analisi dati
Apri schedaISERR
ISERR(value)
Checks whether a value is an error other than `#N/A`. Learn more
Analisi dati
Apri schedaISERROR
ISERROR(value)
Checks whether a value is an error. Learn more
Analisi dati
Apri schedaISFORMULA
ISFORMULA(cell)
Checks whether a formula is in the referenced cell. Learn more
Analisi dati
Apri schedaISLOGICAL
ISLOGICAL(value)
Checks whether a value is `TRUE` or `FALSE`. Learn more
Analisi dati
Apri schedaISNA
ISNA(value)
Checks whether a value is the error `#N/A`. Learn more
Analisi dati
Apri schedaISNONTEXT
ISNONTEXT(value)
Checks whether a value is non-textual. Learn more
Analisi dati
Apri schedaISNUMBER
ISNUMBER(value)
Checks whether a value is a number. Learn more
Analisi dati
Apri schedaISREF
ISREF(value)
Checks whether a value is a valid cell reference. Learn more
Analisi dati
Apri schedaISTEXT
ISTEXT(value)
Checks whether a value is text. Learn more
Analisi dati
Apri schedaN
N(value)
Returns the argument provided as a number. Learn more
Analisi dati
Apri schedaNA
NA()
Returns the "value not available" error, `#N/A`. Learn more
Analisi dati
Apri schedaSHEETS
SHEETS(reference)
Returns the total number of sheets in the referenced spreadsheet. Learn more about the SHEETS function.
Analisi dati
Apri schedaTYPE
TYPE(value)
Returns a number associated with the type of data passed into the function. Learn more
Analisi dati
Apri schedaADDRESS
ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet])
Returns a cell reference as a string. Learn more
Analisi dati
Apri schedaCHOOSE
CHOOSE(index, choice1, [choice2, ...])
Returns an element from a list of choices based on index. Learn more
Analisi dati
Apri schedaCOLUMN
COLUMN([cell_reference])
Returns the column number of a specified cell, with `A=1`. Learn more
Analisi dati
Apri schedaCOLUMNS
COLUMNS(range)
Returns the number of columns in a specified array or range. Learn more
Analisi dati
Apri schedaFORMULATEXT
FORMULATEXT(cell)
Returns the formula as a string. Learn more.
Analisi dati
Apri schedaGETPIVOTDATA
GETPIVOTDATA(value_name, any_pivot_table_cell, [original_column, ...], [pivot_item, ...]
Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings. Learn more
Analisi dati
Apri schedaHLOOKUP
HLOOKUP(search_key, range, index, [is_sorted])
Horizontal lookup. Searches across the first row of a range for a key and returns the value of a specified cell in the column found. Learn more
Analisi dati
Apri schedaINDEX
INDEX(reference, [row], [column])
Returns the content of a cell, specified by row and column offset. Learn more
Analisi dati
Apri schedaINDIRECT
INDIRECT(cell_reference_as_string, [is_A1_notation])
Returns a cell reference specified by a string. Learn more
Analisi dati
Apri schedaLOOKUP
LOOKUP(search_key, search_range|search_result_array, [result_range])
Looks through a row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column. Learn more
Analisi dati
Apri schedaMATCH
MATCH(search_key, range, [search_type])
Returns the relative position of an item in a range that matches a specified value. Learn more
Analisi dati
Apri schedaOFFSET
OFFSET(cell_reference, offset_rows, offset_columns, [height], [width])
Returns a range reference shifted a specified number of rows and columns from a starting cell reference. Learn more
Analisi dati
Apri schedaROW
ROW([cell_reference])
Returns the row number of a specified cell. Learn more
Analisi dati
Apri schedaROWS
ROWS(range)
Returns the number of rows in a specified array or range. Learn more
Analisi dati
Apri scheda