The COUNT IF function in Excel is used to count those cells within the given range with the specific condition. In this article, we will see the usefulness and the versatility of the COUNTIF function.The syntax of the function is as follows:COUNTIF (range, criterion)- The range is the number of cells you specify in your worksheet and this can be specified as A1:A10 or B1:B20.
- The criterion is the condition which enables the Excel to count those cells, out of the range of cells, which meet your requirement. For example, if I set the criterion to count those cells which are greater than 25, the Excel will select these specific cells, count them and will produce the result.
Let us explore this function with some examples having different criterion: |
## AuthorHi! I write posts on growing your business ## Categories## Archives
May 2019
## Categories |