Question

Which of the following function in MS-Excel is used to count cells in a range that meets specific criteria ?

• A. COUNTA
• B. COUNT
• C. COUNTBlANK
• D. COUNTIF

Answer 1

Answer:

D. COUNTIF

The MS-Excel function used to count cells in a range that meets specific criteria is COUNTIF.

---

The COUNTIF function is a statistical function in Excel that counts the number of cells within a specified range that satisfy a given condition or criterion.

Syntax:

COUNTIF(range, criteria)

• range: This is the group of cells from which you want to count.

• criteria: This is the condition that cells must meet to be counted. The criteria can be a number, an expression

  (e.g., ">50"), a cell reference (e.g., A1), text (e.g., "Apple"), or a formula. Text criteria must be enclosed in double quotation marks.