COUNTIFS

  • Updated

Returns the number of elements within a cell range that meet multiple criteria.

Sample Usage

COUNTIFS( B1:B25 ,">10",C1:C25 ,"<20") 
COUNTIFS(A4,A5)

Syntax

COUNTIFS(range1, criteria1, [range2,..], [criteria2,..])

  • range1 - The cells to which the first criteria is applied.
  • criteria1 - The pattern or test to apply to the first range.
  • range2,.. - [OPTIONAL] The cells to which the respective criteria is applied.
  • criteria2,.. - [OPTIONAL] The pattern or test to apply to the respective range.

Examples

COUNTIFS( B1:B25 ,">10",C1:C25 ,"<20")  returns a count of the number of rows that meet the first criteria, and also the second criteria.

 
Notes

  • Any additional ranges must contain the same number of rows and columns as range1.
  • Ensure that criteria1criteria2,.. are in quotation marks.
  • criteria can contain wildcard characters. Currently, the use of asterisk (*) is supported.
    • An asterisk matches any sequence of characters.
    • To match an actual asterisk, type a tilde (~) before the character. For example: (~*).