writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 16:
Line 16: + + Line 155:
Line 157: + +
no edit summary
*The argument 'fld' is optional. If not mentioned, the function counts all the numbers from database that match the criteria.
*The argument 'fld' 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.
*Criteria can be any range on the 'Calci' with minimum of one column and at least one row indicating the condition.
*Criteria can be any range on the 'Calci' with minimum of one column and at least one row indicating the condition.
=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. ''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.
== See Also ==
== See Also ==