Microsoft Office Tutorials and References
In Depth Information
DCOUNTA
A
Field referenced as
a column number
Figure 3.2
The DCOUNT function
counts the number
of cells containing
numbers.
B
Field referenced
as a column
heading
C
A blank field reference produces
a search of the entire data list.
DCOUNTA
DCOUNTA counts nonblank cells containing numbers or text that meet the specified criteria.
=DCOUNTA(database,field,criteria)
The DCOUNTA function operates just as the DCOUNT function, however, it counts the number of
cells containing numbers or text. If you have a database that has values stored as numbers and
cells stored with text, you might need this function to count both storage types. The database
is the cell reference range or named range of the database; and the field is referenced as the
column number from left to right. The criteria is a range that is referenced and the function
operates from the parameters set.
DGE DGET returns a single value that meets the specified criteria.
=DGET(database,field,criteria)
The DGET function extracts a number within a database at two intersecting points. For example, if
you have rate tables used in conjunction with a financial model, the DGET function can be used to
apply rates based on the criteria in the criteria range. The database is the cell reference range or
named range of the database; and the field is referenced as the column number from left to right.
Search JabSto ::




Custom Search