Advanced Excel formula COUNTIF vs COUNTIFs with example

Advanced Excel formula COUNTIF vs COUNTIFs with example

COUNTIF

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

Syntax

=COUNTIF(range,criteria)

  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“:

Output

Note: the arrow shows the occurrence of “DB” in selected range (“A1:A12“) and COUNTIF evaluate result as 3.

COUNTIFS

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.

Syntax

=COUNTIFS(criteria_range1, criteria1,criteria_range2, criteria2….)

Implementation

Output

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.