We can **count cells that are greater than** a **criteria** with the **COUNTIF function**. The steps below will walk through the process.

*Figure 1: How to Count cells greater than*

**Syntax**

**=COUNTIF(range,“>X”)**

**Range**is the**range of values**where we want a count**X**is the**criteria**which the**COUNTIF FUNCTION**returns a count for. This is the value that others should be greater than.

**Formula**

**=COUNTIF(C4:C11,">70")**

**Setting up the Data**

We have subjects offered by a student in a semester. We will **count the marks greater than 70**.

- We will input the
**SUBJECTS**in**Column B** - We will input the
**MARKS**into**Column C** **Cell D4**is where we want the**COUNTIF FUNCTION**to return the result

* Figure 2: Setting up the Data*

**Count Cells Greater Than **

- We will click on
**Cell D4** - We will insert the formula below into the cell

**=COUNTIF(C4:C11,">70")** - We will
**press the enter key**

*Figure 3: Result of Marks Greater than 70*

**Note**

- We can use the formula below to count cells that are greater than an equal to 70

**=COUNTIF(C4:C11,">=70")** - By changing the sign to
**less than sign,**we can count cells that are less than the specified criteria

**Instant Connection to an Expert through our Excelchat Service**

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

## Leave a Comment