In Excel 2010 by using **COUNTIF** conditional logic, you will be able to count occurrence of data and show the result if the condition is met. It enables user to use a condition that contain two arguments (range,criteria), that would be applied on data which yields counting results, only if specified criteria is *TRUE. *Thus facilitating user to create a group for certain type of data that falls into specific category. This post explains simple usage of COUNTIF logic.

Launch Excel 2010, and open a datasheet on which you need to apply formula with COUNTIF function.

For Instance: We will use student grading datasheet, containing student records.

Now for checking how many students have secured *A,* *B+, B, C+, C *grade and how many failed in exam.

Here our primary concern is with *Grade *field, we will write a formula that will check the *Grade *column and count, how many students secured same grades.

Syntax:

=COUNTIF(range, criteria)

Now we apply formula complying with the syntax.

=COUNTIF(E2:E26,"A")

*E2:E26 *in the formula will select column *E *starting with* *row *2, *to the end of the column E26.* *on selected column, a condition is applied that counts how many students secured A grade*. *This formula shows that *9 *students* *secured* A *grade*.*

* *

Now we will create all other categories by changing the conditions that match with corresponding grades.

**B+ Grade Students**

=COUNTIF(E2:E26,"B+")

**B Grade Students**

=COUNTIF(E2:E26,"B")

**C+ Grade Students**

=COUNTIF(E2:E26,"C+")

**C Grade Students**

=COUNTIF(E2:E26,"C")

**Fail Students (D grade)**

=COUNTIF(E2:E26,"D")

The final Grading datasheet is shown in the screenshot below.

You can also checkout previously reviewed SUMIF Function in Excel 2010.

Pingback: Guide On Excel 2010 Data Bars

Pingback: Excel 2010: Radians and Degrees Function

Pingback: Excel 2010: DCOUNT Function

Pingback: Excel 2010 Basic Arithmetic Operation On DATE Values

Pingback: FLOOR.PRECISE Function In Excel 2010