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 isTRUE. 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
=COUNTIF(range, criteria)
| =COUNTIF(A2:A34,"SINGH COMMUNICATION") |
If you want to Count Singh Comm
| =COUNTIF(A2:A34,"SINGH COMMUNICATION") Ans :- 3 |
No comments:
Post a Comment