=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. ''Displays 3'' as a result. |