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.

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.

table22 COUNTIF Function In Excel 2010

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.

قالب وردپرس

About Alyse Kalish

Alyse Kalish
As an Associate Editor for The SalesJobInfo, Alyse is proud to prove that yes, English majors can change the world. She calls many places home, including Illinois where she grew up and the small town of Hamilton where she attended Colgate University, but she was born to be a New Yorker. In addition to being an avid writer, Alyse loves to dance, both professionally and while waiting for the subway.

Leave a Reply

Your email address will not be published. Required fields are marked *