Now for checking how many students have secured A, B+, B, C+, C grade and how many failed in exam. Launch Excel 2010, and open a datasheet on which you need to apply formula with COUNTIF function.įor Instance: We will use student grading datasheet, containing student records. This post explains simple usage of COUNTIF logic. Thus facilitating user to create a group for certain type of data that falls into specific category. 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. 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.
0 Comments
Leave a Reply. |