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.
