Excel Database Functions

This section will learn  how to use Excel’s  Database Functions such as: Daverage, Dcount, DcountA, Dget, Dmax, Dmin, etc.

DAVERAGE – calculates the average of values in a column of a list or database that match conditions you specify.

DCOUNT – function returns the number of cells that containing numbers in a column of a list or a database that match the conditions that you specify.

DCOUNTA – returns the number of cells that containing non-blank values in a column of a list or a database that match the conditions that you specify.

DGET – returns a single value from a database that matches the specified conditions.

DMAX – returns the maximum value from a database or a column of a list that matches the specified conditions.

 

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar