DATABASE Articles: Excel and Google Sheets

The variance derived from the total population can be extracted from a given data range and done by a very useful function of excel, DVARP. If the data does not represent a population but represents a sample, here DVAR function can be used. Function Firstly, the core function of this formula...

The purpose of Excel DMAX function is used to return the maximum values within a field range, derived from a set of records that match those criteria. In opposite to this, the DMIN function is used in order to get the minimum value.  Moreover, DMAX function is to return the maximum...

DMIN is a database function in Excel that returns the number with the smallest value in a list based on one or more criteria.  This tutorial will assist all levels of Excel users in using the DMIN function. Figure 1. Final result of the DMIN function Final formula: =DMIN(B2:E7,C2,B10:E11) Syntax...

Figure 1. of Excel DCOUNTA Function. We can be required to count matching records within a database by using specific criteria and an optional field. To do this, we can utilize the Excel DCOUNTA Function for counting the matching records within our worksheet database. This tutorial will walk through the...

Figure 1. of the Excel DAVERAGE Function. The DAVERAGE Function in Excel is used to determine the average amount of data records within a range of data that matches a specific criteria. This tutorial will step through how to use the DAVERAGE function. Generic Formula DAVERAGE(database, field, criteria) We are...

If we want to get the sum of given records that match a given specified criteria, we can use the excel DSUM function. In this article, we will provide a clear guide on how use the excel DSUM function. Figure 1: How to use the DSUM function in excel General...

Excel allows a user to get a single value from a database using the DGET function. This step by step tutorial will assist all levels of Excel users in getting a value from a database for given criteria. Figure 1. The result of the function Syntax of the DGET Formula...

DVAR is a database function in Excel that returns the variance of a population by using the samples that match the given criteria.  This tutorial will assist all levels of Excel users in the usage and syntax of DVAR function. Figure 1. Final result of the DVAR function Final formula:...

Excel allows a user to calculate the standard derivation using the DSTDEVP functions. This step by step tutorial will assist all levels of Excel users in calculating the standard deviation for the population. Figure 1. The result of the DSTDEVP function Syntax of the DSTDEVP Formula The generic formula for...

Excel allows a user to count records from a database based on a given criteria, using the DCOUNT function. This step by step tutorial will assist all levels of Excel users in counting matching records from a database. Figure 1. The result of the DCOUNT function Syntax of the DCOUNT...