writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 154:
Line 154: + + + + + + + + +
no edit summary
=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.
== See Also ==
*[[Manuals/calci/DCOUNTA| DCOUNTA]]
==References==
*[http://en.wikipedia.org/wiki/Aggregate_function List of Aggregate Functions]
*[http://en.wikipedia.org/wiki/Aggregate_function DCOUNT]