• • Database – range of cells, where your database is

• • Field – name or numer of column where values are

• • Criteria – your criteria – they should contain name of column and name of some value from that column

Let’s see train that with examples. This is example database:

DAVERAGE

This function shows average of values which meet your criteria. This is the example:

Syntax:

=DAVERAGE($A$1:$C$11;3;$A$1:$A$2) or =DAVERAGE($A$1:$C$11;”Sales”;$A$1:$A$2)

DCOUNT

This function shows count of cells which meet your criteria. This is the example:

Syntax: 

=DCOUNT($A$1:$C$11,3,$E$2:$E$3) or =DCOUNT($A$1:$C$11,”Sales”,$E$2:$E$3)

DCOUNTA

This function shows count of noblank cells which meet your criteria. DCOUNTA function works similar to DCOUNT function. This is the example:

Syntax: 

=DCOUNTA($A$1:$C$11,3,$E$2:$E$3) or =DCOUNTA($A$1:$C$11,”Sales”,$E$2:$E$3)

DGET

This function shows single value which meet your criteria. This is the example:

Syntax: 

=DGET($A$1:$C$11,3,A1:A2) or =DGET($A$1:$C$11,”Sales”,A1:A2)

DMAX

This function shows max value which meet your criteria. This is the example:

Syntax: 

=DMAX($A$1:$C$11,3,$A$1:$A$2) or =DMAX($A$1:$C$11,”Sales”,$A$1:$A$2)

DMIN

This function shows min value which meet your criteria. This is the example:

Syntax: 

=DMIN($A$1:$C$11,3,$A$1:$A$2) or =DMIN($A$1:$C$11,”Sales”,$A$1:$A$2)

DPRODUCT

This function shows multiplication of values which meet your criteria. This is the example:

Syntax: 

=DPRODUCT($A$1:$C$11,3,$A$1:$A$2) or =DPRODUCT($A$1:$C$11,”Sales”,$A$1:$A$2)

DSTDEV

This function estimates standard deviation of values which meet your criteria. This is the example:

Syntax: 

=DSTDEV($A$1:$C$11,3,$A$1:$A$2) or =DSTDEV($A$1:$C$11,”Sales”,$A$1:$A$2)

DSTDEVP

This function estimates standard deviation based of whole population of values which meet your criteria. This is the example:

Syntax: 

=DSTDEVP($A$1:$C$11,3,$A$1:$A$2) or =DSTDEVP($A$1:$C$11,”Sales”,$A$1:$A$2)

DSUM

This function shows sum of values which meet your criteria. This is the example:

Syntax: 

=DSUM($A$1:$C$11,3,$A$1:$A$2) or =DSUM($A$1:$C$11,”Sales”,$A$1:$A$2)

DVAR

This function estimates variance of values which meet your criteria. This is the example:

Syntax: 

=DVAR($A$1:$C$11,3,$A$1:$A$2) or =DVAR($A$1:$C$11,”Sales”,$A$1:$A$2)

DVARP

This function estimates variance of values which meet your criteria based on entire population. This is the example:

Syntax: 

=DVARP($A$1:$C$11,3,$A$1:$A$2) or =DVARP($A$1:$C$11,”Sales”,$A$1:$A$2)