Excel: CountIf Function

In Excel, the CountIf function counts the number of cells in a range, that meets a given criteria.

The syntax for the CountIf function is:

CountIf( range, criteria )

range is the range of cells that you want to count based on the criteria.

criteria is used to determine which cells to count.

Based on the Excel spreadsheet above:

=CountIf(A2:A7, D2)	would return 1
=CountIf(A:A, D2)	would return 1
=CountIf(A2:A7, ">=2001")	would return 4

Excel: CountIf Function

Powered by ScribeFire.