Changes

no edit summary
Line 146: Line 146:  
| class="sshl_f" |
 
| class="sshl_f" |
 
|}
 
|}
 +
    
=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. ''Displays 3'' as a result.
writer
2,661

edits