Difference between revisions of "Manuals/calci/DCOUNTA"

Latest revision as of 13:46, 24 August 2018

DCOUNTA (Array,Field,Criteria)

Where 'Array' is the range of cells that makes up the list or database
'Field' shows which column is used in the function and
'Criteria' is the range of cells that contains the specified criteria.
- DCOUNTA() Counts nonblank cells in a database.

Description

DCOUNTA (Array,Field,Criteria)

It counts the nonblank cells in a column of a list or database that match conditions that we specify.

The argument 'Field' is optional. If not mentioned, the function counts all the numbers from database that match the criteria.

A 'column name' in quotes (e.g "Salary") or 'column number' (e.g 3, if Salary is 3rd column) can be used as 'field' argument.

Criteria can be any range on the 'Calci' with minimum of one column and at least one row indicating the condition.

The Criteria columns should not overlap the list of data.

DCOUNT() can be used to count the number of cells from a list of database that are numbers and match a specified criteria.

Examples

Consider the following table with Employee names, Age and Salary columns. Row1 to Row3 has the criteria fields. Row4 to Row10 display the actual data.

?

	A	B	C	D
1	Name	Age	Salary	Age
2		<40	>5000	>32
3		>30
4	Name	Age	Salary
5	John	34	5500
6	Bill	35	6500
7	Clark	29	7000
8	Bob	45
9	Susan	37	4000
10	Jill	45	8000

=DCOUNTA(A4:C10,"Salary",A1:C2) : Counts the number of non-blank cells in the 'Salary' column, in the range A4 to C10, for the employees whose Age<40 and Salary>5000.
Displays 3 as a result.

=DCOUNTA(A4:C10,"Salary",D1:D2) : Counts the number of non-blank cells in the 'Salary' column, in the range A4 to C10, for the employees whose Age>32.
Displays 4 as a result.

There are 5 cells in Salary column with Employee Age>32, but Salary field for Employee Bob is blank. Hence result displayed is '4'.

=DCOUNTA(A4:C10,3,D1:D2) : Counts the number of non-blank cells in the 3rd column ('Salary'), in the range A4 to C10, for the employees whose Age>32.
Displays 4 as a result.

There are 5 cells in Salary column with Employee Age>32, but Salary field for Employee Bob is blank. Hence result displayed is '4'.

References

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-=DCOUNTA(db, fld, cri)=
+<div style="font-size:30px">'''DCOUNTA (Array,Field,Criteria)'''</div><br/>
+*Where 'Array' 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
+*'Field' shows which column is used in the function and
+*'Criteria' is the range of cells that contains the specified criteria.
-*'fld' shows which column is used in the function and
+**DCOUNTA() Counts nonblank cells in a database.
-*'cri' is the range of cells that contains the specified criteria.
-*DCOUNTA() counts the non-blank cells in the column of a list or database that match the specified criteria.
 == Description ==
-DCOUNTA(db, fld, cri)
+DCOUNTA (Array,Field,Criteria)
-It counts the nonblank cells in a column of a list or database that match conditions that we specify.</font></font></font>
+It counts the nonblank cells in a column of a list or database that match conditions that we specify.
-*The argument 'fld' is optional. If not mentioned, the function counts all the numbers from database that match the criteria.
+*The argument 'Field' is optional. If not mentioned, the function counts all the numbers from database that match the criteria.
-* A 'column name' in quotes (e.g "Salary") or 'column number' (e.g 3, if Salary is 3rd column) can be used as 'fld' argument.
+* A 'column name' in quotes (e.g "Salary") or 'column number' (e.g 3, if Salary is 3rd column) can be used as 'field' argument.
 *Criteria can be any range on the 'Calci' with minimum of one column and at least one row indicating the condition.
@@ Line 30: / Line 26: @@
 Row1 to Row3 has the criteria fields. Row4 to Row10 display the actual data.
-<!--
+<div id="2SpaceContent" class="zcontent" align="left">
-<div id="8SpaceContent" class="zcontent" align="left">
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">Let's see an example</font>]
-<font color="#0000ff"><br /></font>
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">C1 C2 C3 </font>]
-<font color="#0000ff"><br /></font>
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R1 Name Age Salary </font>]
-<font color="#0000ff"><br /></font>
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R2 &lt;30 </font>]
-<font color="#0000ff"><br /></font>
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R3 &gt;40 &gt;5000</font>]
-<font color="#0000ff"><br /></font>
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R4 Name Age Salary</font>]
-<font color="#0000ff"><br /></font>
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R5 John 34 5500 </font>]
-<font color="#0000ff"><br /></font>
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R6 Bill 35 6500 </font>]
-<font color="#0000ff"><br /></font>
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R7 Clark 29 7000 </font>]
-<font color="#0000ff"><br /></font>
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R8 Bob 45 9000</font>]
-<font color="#0000ff"><br /></font>
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R9 Susan 37 4000</font>]
-<font color="#0000ff"><br /></font>
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R10 Jill 45 8000 </font>]
-<font color="#0000ff"><br /></font>
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">I.e =DCOUNTA(C1R4:C3R10,”Salary”,C1R1:C2R3) is 3</font>]
-</div>
--->
-<!--
-----
-<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
-----
-<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
-----
-<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
-----
--->
-<div id="2SpaceContent" class="zcontent" align="left">
 {| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
+| class="sshl_f" |
+| class="sshl_f" | A
+| class="sshl_f" | B
+| class="sshl_f" | C
+| class="sshl_f" | D
+|- class="odd"
+| class="sshl_f " | 1
 | class="sshl_f " | '''Name'''
 | class="sshl_f" | '''Age'''
 | class="sshl_f" | '''Salary'''
 | class="sshl_f" | '''Age'''
-|- class="odd"
+|- class="even"
+| class="sshl_f " | 2
 | class="sshl_f" |
 | class="sshl_f" | &lt;40
@@ Line 109: / Line 48: @@
 | class="sshl_fSelectTD SelectTD " | &gt;32
 <div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
-|- class="even"
+|- class="odd"
+| class="sshl_f " | 3
 | class="sshl_f" |
 | class="sshl_f " | &gt;30
 | class="sshl_f" |
 | class="sshl_f" |
-|- class="odd"
+|- class="even"
+| class="sshl_f " | 4
 | class="sshl_f   " | '''Name'''
 | class="sshl_f" | '''Age'''
 | class="sshl_f" | '''Salary'''
 | class="sshl_f" |
-|- class="even"
+|- class="odd"
+| class="sshl_f " | 5
 | class="sshl_f" | John
 | class="sshl_f" | 34
 | class="sshl_f" | 5500
 | class="sshl_f" |
-|- class="odd"
+|- class="even"
+| class="sshl_f " | 6
 | class="sshl_f" | Bill
 | class="sshl_f" | 35
 | class="sshl_f" | 6500
 | class="sshl_f  " |
-|- class="even"
+|- class="odd"
+| class="sshl_f " | 7
 | class="sshl_f" | Clark
 | class="sshl_f" | 29
 | class="sshl_f" | 7000
 | class="sshl_f" |
-|- class="odd"
+|- class="even"
+| class="sshl_f " | 8
 | class="sshl_f" | Bob
 | class="sshl_f" | 45
 | class="sshl_f" |
 | class="sshl_f" |
-|- class="even"
+|- class="odd"
+| class="sshl_f " | 9
 | class="sshl_f" | Susan
 | class="sshl_f" | 37
 | class="sshl_f" | 4000
 | class="sshl_f" |
-|- class="odd"
+|- class="even"
+| class="sshl_f " | 10
 | class="sshl_f" | Jill
 | class="sshl_f" | 45
@@ Line 151: / Line 98: @@
 |}
-=DCOUNTA(A4:C10,"Salary",A1:C2)   : Counts the number of non-blank cells in the 'Salary' column, in the range A4 to C10, for the employees whose Age<40 and Salary>5000. ''Displays 3'' as a result.
+=DCOUNTA(A4:C10,"Salary",A1:C2)   : Counts the number of non-blank cells in the 'Salary' column, in the range A4 to C10, for the employees whose Age<40 and Salary>5000. <br>Displays '''3''' as a result.
-=DCOUNTA(A4:C10,"Salary",D1:D2)   : Counts the number of non-blank cells in the 'Salary' column, in the range A4 to C10, for the employees whose Age>32.''Displays 4'' as a result.
+=DCOUNTA(A4:C10,"Salary",D1:D2)   : Counts the number of non-blank cells in the 'Salary' column, in the range A4 to C10, for the employees whose Age>32.<br>Displays '''4''' as a result.
 There are 5 cells in Salary column with Employee Age>32, but Salary field for Employee Bob is blank. Hence result displayed is '4'.
-=DCOUNTA(A4:C10,3,D1:D2)          : Counts the number of non-blank cells in the 3rd column ('Salary'), in the range A4 to C10, for the employees whose Age>32.''Displays 4'' as a result.
+=DCOUNTA(A4:C10,3,D1:D2)          : Counts the number of non-blank cells in the 3rd column ('Salary'), in the range A4 to C10, for the employees whose Age>32.<br>Displays '''4''' as a result.
 There are 5 cells in Salary column with Employee Age>32, but Salary field for Employee Bob is blank. Hence result displayed is '4'.
+== Related Videos ==
+{{#ev:youtube|D_1-SavHX-M|280|center|DCOUNTA}}
 == See Also ==
@@ Line 169: / Line 119: @@
 *[http://en.wikipedia.org/wiki/Aggregate_function List of Aggregate Functions]
 *[http://en.wikipedia.org/wiki/Aggregate_function DCOUNTA]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]

Difference between revisions of "Manuals/calci/DCOUNTA"

Latest revision as of 13:46, 24 August 2018

Contents

Description

Examples

Related Videos

See Also

References

Navigation menu

Search