The COUNTIF function counts the number of cells that meet one criterion, such as the cells with a text string, the cells with a certain value, etc. The following formula is to help you get the count of cells greater than a particular value.
Example: You are working with a dataset with the first name in column A, the last name in column B, and the salary in column C.
Formula 1: How many persons' salaries are over $70,256?
= COUNTIF(C2:C8, ">70256")
The result returns four, and there are four people with a salary of over $70,256.
Formula 2: To count how many persons' salaries are over $60,000
= COUNTIF(C2:C8, ">60000")
The result returns 6, and there are six people with a salary of over $60,000.
Notes: The COUNTIF function
= COUNTIF(Range, ">Number")
– The range is required, the range of cells you want to count;
– ">Number" is required, which is the base number.
Practice: Count Cells Greater than