Wednesday, 17 July 2013

Excel COUNTIF Function Syntax and Example

How find Count based on a specific Criteria in Excel
CountIF is a function which used to find the count of a particular value (how many times it repeated in the given data) in the given array or range of data.

Syntax:
=CountIF(Array,Criteria)

Here:
  • Array is a list or range of data where you want to find the count based on Criteria.
  • Criteria is a condition based on which you want to find count.
Example:

Data
Criteria
COUNTIF Formula
Result
125
 ">=50"
 =COUNTIF($A$1:$A$10,">=50")
2
345_End
"*End"
 =COUNTIF($A$1:$A$10,"*End")
3
50
"345*"
 =COUNTIF($A$1:$A$10,"345*")
2
45
345_Start
123_End
25
10
5_End


Note:
If the value that you want to count is not existed in given range of data then its count is “0”.

Thanks,

TAMATAM

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts