Question

Which function in MS EXCEL is used to count the number of cells that meet a criterion?

• A. COUNT
• B. IF
• C. COUNTIF
• D. SUM

Answer 1

Answer:

C. COUNTIF

• The function in MS Excel used to count the number of cells that meet a criterion is : COUNTIF
• The COUNTIF function counts the number of cells in a range that meet a specified condition or criterion. It takes two arguments:

1. Range : The range of cells to count.
2. Criteria : The condition or criterion to apply.

• There's also a related function called COUNTIF, which allows you to apply multiple criteria to a range.