DCOUNT
This is the Database range.
What Does It Do ?
This function examines a list of information and counts the values in a specified column.
It can only count values, the text items and blank cells are ignored.
It can only count values, the text items and blank cells are ignored.
Syntax
=DCOUNT(DatabaseRange,FieldName,CriteriaRange)
=DCOUNT(DatabaseRange,FieldName,CriteriaRange)
The Database Range is the entire list of information you need to examine, including the
field names at the top of the columns.
The FieldName is the name, or cell, of the values to Count, such as “Value Of Stock” or I3.
The Criteria Range is made up of two types of information.
The first set of information is the name, or names, of the Fields(s) to be used as the basis
for selecting the records, such as the category Brand or Wattage.
The second set of information is the actual record, or records, which are to be selected, such
as Horizon as a brand name, or 100 as the wattage.
field names at the top of the columns.
The FieldName is the name, or cell, of the values to Count, such as “Value Of Stock” or I3.
The Criteria Range is made up of two types of information.
The first set of information is the name, or names, of the Fields(s) to be used as the basis
for selecting the records, such as the category Brand or Wattage.
The second set of information is the actual record, or records, which are to be selected, such
as Horizon as a brand name, or 100 as the wattage.
Formatting
No special formatting is needed.
No special formatting is needed.
Examples
The count of a particular product, with a specific number of boxes in stock.
The count of a particular product, with a specific number of boxes in stock.
The count of the number of Bulb products equal to a particular Wattage.
The count of Bulb products between two Wattage values.
