Database Functions

The Excel Database Functions have been provided to help you to work with a database - ie. a large number of data records, stored in Excel.

The database functions perform basic operations, such as sum, average, count, etc, but they include criteria arguments, which enable you to only include some of the records from your database in the calculation. Other records in the database are ignored.

The current, built-in Excel Database Functions are listed in the table below. Select one of function names, to go to a full description of the function with examples of use.