Which Excel function is used to count the number of cells in a range that meet a specific condition?

a) COUNTIF

b) SUMIF

c) AVERAGEIF

d) IFERROR

Show answer

a) COUNTIF

The Excel function used to count the number of cells in a range that meet a specific condition is the COUNTIF function. COUNTIF allows you to specify a range of cells and a condition, and it counts the number of cells within that range that meet the specified condition. The basic syntax of the COUNTIF function is as follows:

=COUNTIF(range, criteria)

• “range” is the range of cells you want to count.
• “criteria” is the condition that cells in the range must meet in order to be counted.

For example, if you want to count the number of cells in the range A1:A10 that contain the value “Apples,” you would use the following formula:

=COUNTIF(A1:A10, “Apples”)

This formula will return the count of cells in the range A1:A10 that contain the text “Apples.”