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
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.
DCOUNT
DCOUNT(database, field, criteria)
Counts numeric values selected from a database table-like array or range using a SQL-like query. Learn more
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
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
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
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
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
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
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
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
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
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
Apri scheda