COUNTIF Function In Excel 2010

In Stand out 2010 by using COUNTIF provisionary logic, you will embody able to count occurrence of data and show the lead if the condition is met. It enables drug user to habit a condition that contain two arguments (range,criteria), that would be practical 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 taxonomic category class. This post explains half-witted usage of COUNTIF system of logic.

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

For example: We will utilization student grading datasheet, containing student records.

marks sheet

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

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

Sentence structure:

=COUNTIF(range, criteria)

Now we give 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 tower E26. on selected newspaper column, a train is applied that counts how many students secured A rank. This rule shows that 9 students secured A grade.

table 2[2]

Now we will produce all other categories past 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")

Die Students (D grade)

=COUNTIF(E2:E26,"D")

The final Leveling datasheet is shown in the screenshot below.

table 3[3]

You can too check previously reviewed SUMIF Operate in Excel 2010.