| DAVERAGE |
Indicates the average of the values that meet the specified criteria. |
| DCOUNT |
Counts the number of cells containing numbers that meet the specified criteria. |
| DCOUNTA |
Counts nonblank cells containing numbers or text that meet the specified criteria. |
| DGET |
Returns a single value that meets the specified criteria. |
| DMAX |
Extracts the highest value that meets the specified criteria. |
| DMIN |
Extracts the lowest value that meets the specified criteria. |
| DPRODUCT |
Returns the product of the values that meet the specified criteria. |
| DSTDEV |
Estimates the standard deviation of a population, based on a sample of selected entries from the database. |
| DSTDEVP |
Returns the calculation of the standard deviation of a population, based on the sum of the whole population. |
| DSUM |
Returns the total of the values that meet the specified criteria. |
| DVAR |
Estimates the variance of a sample population based on the values that meet the specified criteria. |
| DVARP |
Returns the calculation of the true variance of an entire population based on the values that meet the specified criteria. |