COUNTIFS returns the number of cells in a range on the base of multiple criteria in the parameter.

Syntax of COUNTIFS  formula:

COUNTIFS( criteria range1, criteria1,.. )

Parameters Details

  • criteria range1 : Frist range of cells that you want to count based on the criteria.
  • criteria1 : Frist criteria used to determine which cells to count.
  • : Next criteria range and next criteria.


The COUNTIFS function returns a numeric value.

COUNTIFS Formula in Excel
COUNTIFS Formula in Excel