How to Count Cells with Values Greater than

The COUNTIF function is to count the number of cells that meet one criterion such as the cells with a text string, and the cells with a certain value, etc. The following formula is to help you get the count of cells that are 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: To count how many persons' salaries are over $70,256

= COUNTIF(C2:C8, ">70256")

The salaries are in column C. The result returns 4 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 salaries are in column C. The result returns 6 and there are six people with a salary of over $60,000.

Notes: The COUNTIF function

Formula:

= COUNTIF(Range, ">Number")

Explanations:

– 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

Leave a Reply