writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 27:
Line 27: − + Line 34:
Line 34: − + + + + + + + + − + − + + − + − + + − + + − + + − + + − + + − + + − + + − + + Line 87:
Line 103: − + − + − + − + − +
→Examples
== Examples ==
== Examples ==
Consider the following table with Employee names, Age and Salary columns.
Consider the following table in ZCalci with Employee names, Age and Salary columns.
Row1 to Row3 has the criteria fields. Row4 to Row10 display the actual data.
Row1 to Row3 has the criteria fields. Row4 to Row10 display the actual data.
UNIQe5afd1fc935bfb36-item-3--QINU
UNIQe5afd1fc935bfb36-item-3--QINU
{| id="TABLE3" class="SpreadSheet blue"
{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
|- class="even"
| class="sshl_f " | '''Name'''
| 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" | '''Age'''
| class="sshl_f" | '''Salary'''
| class="sshl_f" | '''Salary'''
| class="sshl_f" | '''Age'''
| class="sshl_f" | '''Age'''
|- class="odd"
|- class="even"
| class="sshl_f" |
| class="sshl_f "| 2
| class="sshl_f "|
| class="sshl_f" | <40
| class="sshl_f" | <40
| class="sshl_f" | >5000
| class="sshl_f" | >5000
| class="sshl_fSelectTD SelectTD " | >32
| class="sshl_fSelectTD SelectTD " | >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>
<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" |
| class="sshl_f" | 3
| class="sshl_f "|
| class="sshl_f " | >30
| class="sshl_f " | >30
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
|- class="even"
| class="sshl_f "| 4
| class="sshl_f " | '''Name'''
| class="sshl_f " | '''Name'''
| class="sshl_f" | '''Age'''
| class="sshl_f" | '''Age'''
| class="sshl_f" | '''Salary'''
| class="sshl_f" | '''Salary'''
| class="sshl_f" |
| class="sshl_f" |
|- class="even"
|- class="odd"
| class="sshl_f "| 5
| class="sshl_f" | John
| class="sshl_f" | John
| class="sshl_f" | 34
| class="sshl_f" | 34
| class="sshl_f" | 5500
| class="sshl_f" | 5500
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
|- class="even"
| class="sshl_f "| 6
| class="sshl_f" | Bill
| class="sshl_f" | Bill
| class="sshl_f" | 35
| class="sshl_f" | 35
| class="sshl_f" | 6500
| class="sshl_f" | 6500
| class="sshl_f " |
| class="sshl_f " |
|- class="even"
|- class="odd"
| class="sshl_f "| 7
| class="sshl_f" | Clark
| class="sshl_f" | Clark
| class="sshl_f" | 29
| class="sshl_f" | 29
| class="sshl_f" | 7000
| class="sshl_f" | 7000
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
|- class="even"
| class="sshl_f "| 8
| class="sshl_f" | Bob
| class="sshl_f" | Bob
| class="sshl_f" | 45
| class="sshl_f" | 45
| class="sshl_f" | 9000
| class="sshl_f" | 9000
| class="sshl_f" |
| class="sshl_f" |
|- class="even"
|- class="odd"
| class="sshl_f "| 9
| class="sshl_f" | Susan
| class="sshl_f" | Susan
| class="sshl_f" | 37
| class="sshl_f" | 37
| class="sshl_f" | 4000
| class="sshl_f" | 4000
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
|- class="even"
| class="sshl_f "| 10
| class="sshl_f" | Jill
| class="sshl_f" | Jill
| class="sshl_f" | 45
| class="sshl_f" | 45
=DCOUNT(A4:C10,"Salary",A1:C2) : Counts the number of 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.
=DCOUNT(A4:C10,"Salary",A1:C2) : Counts the number of 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.
=DCOUNT(A4:C10,"Age",A1:C2) : Counts the number of cells in the 'Age' column, in the range A4 to C10, for the employees whose Age<40 and Salary>5000. ''Displays 3'' as a result.
=DCOUNT(A4:C10,"Age",A1:C2) : Counts the number of cells in the 'Age' column, in the range A4 to C10, for the employees whose Age<40 and Salary>5000. <br>Displays '''3''' as a result.
=DCOUNT(A4:C10,"Salary",A1:C3) : Counts the number of cells in the 'Salary' column, in the range A4 to C10, for the employees whose Age<40 and Salary>5000 in addition to employees whose Age>30. ''Displays 8'' as a result.
=DCOUNT(A4:C10,"Salary",A1:C3) : Counts the number of cells in the 'Salary' column, in the range A4 to C10, for the employees whose Age<40 and Salary>5000 in addition to employees whose Age>30. <br>Displays '''8''' as a result.
=DCOUNT(A4:C10,"Salary",A1:C2)-DCOUNT(A4:C10,"Salary",A1:D2) : Counts the difference in the number of cells in the 'Salary' column for employees whose Age<40 and Salary>5000, and employees with 40<Age>32 and salary>5000, in the range A4 to C10. ''Displays 1 ''(3-2=1) as a result.
=DCOUNT(A4:C10,"Salary",A1:C2)-DCOUNT(A4:C10,"Salary",A1:D2) : Counts the difference in the number of cells in the 'Salary' column for employees whose Age<40 and Salary>5000, and employees with 40<Age>32 and salary>5000, in the range A4 to C10. <br>Displays '''1 '''(3-2=1) as a result.
=DCOUNT(A4:C10,3,A1:C2) : Counts the number of cells in the 3rd column ('Salary'), in the range A4 to C10, for the employees whose Age<40 and Salary>5000. ''Displays 3'' as a result.
=DCOUNT(A4:C10,3,A1:C2) : Counts the number of cells in the 3rd column ('Salary'), in the range A4 to C10, for the employees whose Age<40 and Salary>5000. <br>Displays '''3''' as a result.
== Related Videos ==
== Related Videos ==