Database Function in Calc Spreadsheet

Database functions –

The database functions always take three arguments Database, Database field and search criteria.

1. Database- is the cell range defining the database. 

2. Database Field- Specifies the column where the function operates on after the search criteria of the first parameter is applied and the data rows selected.

3. Search Criteria- Search Criteria always shown in the separate table. It is the cell range containing search criteria. If you write several criteria in one row then they are connected by AND.

DSUM –

DSUM returns the total of all cells in a database field in all rows (records) that match the specified search criteria.

Syntax:-  

=DSUM(Database, Database field, search Criteria) : The range of cells containing data

Example: 

=DSUM(B3:C13,C3,E3:E4)

DMIN –

DMIN returns the minimum content of a field in a database that matches the specified search criteria.

Syntax:- 

=DMIN (Database, Database Field, Search Criteria) : Defines the cell ranges containing search criteria.

Example:

=DMIN(B3:C13,C3,E3:E4)

DMAX –

It returns the maximum content of a field in a database (all records) that matches the specified search criteria.

Syntax:- 

=DMAX (Database; Database field; Search Criteria) : Defines the cell ranges containing search criteria.

Example:

=DMAX(B3:C13,C3,E3:E4)

DCOUNT –

DCOUNT function counts the number of rows (records) in a database that match the specified search criteria and contain numerical values in the Database Field column. 

Syntax: 

=DCOUNT(Database, Database Field, Search Criteria) : Defines the cell ranges containing search criteria.

Example: 

=DCOUNT(B3:C13,C3,E3:E4)

DCOUNTA –

It counts the contents of all non-blanks cell of data range where content corresponds to the search criteria. 

Syntax- 

=DCOUNTA(Database, Database Field, Search Criteria) : Defines the cell ranges containing search criteria.

Example: 

=DCOUNTA(B3:C13,C3,E3:E4)