COUNTIF is an Excel function to count cells in a range that meet a single condition in the given formula.
- Range: is an argument which refers to the range in which count needs to be done
- Criteria: refers to the condition which needs to be evaluated on above Range
Put following formula as shown below where we will be counting Cars whose name is “DB“:
Note: the arrow shows the occurrence of “DB” in selected range (“A1:A12“) and COUNTIF evaluate result as 3.
Evaluates multiple conditions and returns a single result as COUNT from the given range. Ideally it is very useful function which helps evaluating multiple conditions like sql queries.
=COUNTIFS(criteria_range1, criteria1,criteria_range2, criteria2….)
Please leave your comments or queries under comment section also please do subscribe to out blogs to keep your self upto date.