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.
Now we apply formula complying with the syntax.
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
B Grade Students
C+ Grade Students
C Grade Students
Fail Students (D grade)
The final Grading datasheet is shown in the screenshot below.
You can also checkout previously reviewed SUMIF Function in Excel 2010.