All resources related to DATABASE for Excel and Google Sheets.

Excel DVARP Function

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...

Learn How to Use the Excel DMAX Function

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...

Excel DMIN Function

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...

Excel DCOUNTA Function

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...

Excel DAVERAGE Function

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...

A Guide on the Excel DSUM Function

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...

Pro Tips on the Excel DGET Function

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...

Excel DVAR Function

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:...

How to Use the Excel DSTDEVP Function

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...

How to Use the Excel DCOUNT Function

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...