It Counts the number of cells within a range that meet the given criteria.
Syntax
COUNTIF(range,criteria)
Range is the range of cells from which you want to count cells.
A Criteria is the criteria in the form of a number, expression, or text that defines which cells will be counted. For example, criteria can be expressed as 32, "32", ">32", "apples".
Example
A | B | D | |
1 | Data | Data | Count If |
2 | apples | 32 | =COUNTIF(A2:A5,"apples”) |
3 | oranges | 54 | |
4 | peaches | 75 | |
5 | apples | 86 |
Counts the number of apples written as text in the range A2 to A5, and returns the count. This will result 2. |
awesome blog
ReplyDeleteHey Dude... You remember I asked you one day that - Is there a way to pull data by a formula like Pivot Table Does (Like pulling data based on Multiple criteria's). I just found out it can be done by function "SUMPRODUCT".. Will be nice to add this function in this blog entry.
ReplyDeleteRAHUL SAXENA