Advanced Excel formula COUNTIF vs COUNTIFs with example

Advanced Excel formula COUNTIF vs COUNTIFs with example


COUNTIF is an Excel function to count cells in a range that meet a single condition in the given formula.



  1. Range: is an argument which refers to the range in which count needs to be done
  2. Criteria: refers to the condition which needs to be evaluated on above Range

Data source

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.

Leave a Reply

Your email address will not be published. Required fields are marked *