1. Home
  2. MS Office

COUNTIF Function In Excel 2010

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.

marks sheet

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.

table 2[2]

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.

table 3[3]

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

Leave a comment