In Excel, which function would you use to count the number of cells in a range that meet a specific condition?
Show answer & explanation
Correct answer: D
Explanation
The correct answer is Option 4, i.e. =COUNTIF(A1:A10, ">10").
In Microsoft Excel, the COUNTIF function counts cells that meet a specified condition.
Syntax:
COUNTIF(range, criteria)
Example:
=COUNTIF(A1:A10, ">50")
This counts how many cells in A1:A10 have values greater than 50.
Key Point:
- Works with a single condition
- Very useful for filtering/counting based on rules without deleting data