Expand Minimize

WorksheetFunction.CountIf Method (Excel)

Counts the number of cells within a range that meet the given criteria.

expression .CountIf(Arg1, Arg2)

expression A variable that represents a WorksheetFunction object.

Parameters

Name

Required/Optional

Data Type

Description

Arg1

Required

Range

The range of cells from which you want to count cells.

Arg2

Required

Variant

The criteria in the form of a number, expression, cell reference, or text that defines which cells will be counted. For example, criteria can be expressed as 32, "32", ">32", "apples", or B4.

Return Value

Double

  • You can use the wildcard characters, question mark (?) and asterisk (*), for the criteria. A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.

Show:
© 2015 Microsoft