The records are treated as a sample, not as the whole population.ĭVARP calculates the variance of the entries in a column of a database table, in rows that meet the criteria. The records are treated as the whole population, not as a sample of the population.ĭSUM returns the total of the entries in a column of a database table, in rows that meet the criteria.ĭVAR returns the variance of the entries in a column of a database table, in rows that meet the criteria. The records are treated as a sample, not as the whole population.ĭSTDEVP calculates the standard deviation of the entries in a column of a database table, in rows that meet the criteria. DCOUNT counts the numerical entries in a column of a database table, that are in rows meeting the criteria.ĭCOUNTA counts the non-empty cells in a column of a database table, that are in rows meeting the criteria.ĭGET returns the contents of a cell in a column of a database table, in the unique row meeting the criteria.ĭMAX returns the largest value in a column of a database table, in rows that meet the criteria.ĭMIN returns the smallest value in a column of a database table, in rows that meet the criteria.ĭAVERAGE returns the average of the entries in a column of a database table, in rows that meet the criteria.ĭPRODUCT returns the product of the entries in a column of a database table, in rows that meet the criteria.ĭSTDEV calculates the standard deviation of the entries in a column of a database table, in rows that meet the criteria.

Openoffice calc database