Open main menu
Home
Random
Log in
Settings
About ZCubes Wiki
Disclaimers
ZCubes Wiki
Search
Changes
← Older edit
Newer edit →
Manuals/calci/DCOUNT
(view source)
Revision as of 22:51, 6 November 2013
7 bytes removed
,
22:51, 6 November 2013
no edit summary
Line 1:
Line 1:
=DCOUNT(db, fld, cri)=
=DCOUNT(db, fld, cri)=
−
*Where db is the range of cells that makes up the list or database
+
*Where
'
db
'
is the range of cells that makes up the list or database
*'fld' shows which column is used in the function and
*'fld' shows which column is used in the function and
−
*'cri' is the range of cells that contains the
conditions that we specify
.
+
*'cri' is the range of cells that contains the
specified criteria
.
== Description ==
== Description ==
Line 11:
Line 11:
DCOUNT(db, fld, cri)
DCOUNT(db, fld, cri)
−
It counts the cells that contain numbers in a column
of a list
or database that match
conditions we specify
.
+
It counts the cells that contain numbers in a
listed
column or database that match
the specified condition
.
<!--
<!--
Swapna
writer
2,661
edits