Correct Answer:
D. COUNTIF
In MS Excel, the COUNTIF function is specifically designed to count the number of cells within a specified range that meet a single given condition or criterion. This is incredibly useful for conditional data analysis.
- COUNTIFB is not a standard or recognized function in MS Excel.
- COUNTA counts the number of cells in a range that are not empty, regardless of their content type (numbers, text, errors).
- COUNT counts the number of cells in a range that contain only numbers. It ignores empty cells and cells containing text or logical values.