This topic has not yet been rated - Rate this topic

COUNT Function

SQL Server 2012

The COUNT function counts the number of cells in a column that contain numbers.


COUNT(<column>)

Parameters

Term	Definition
column	The column that contains the numbers to be counted

Return Value

A whole number.

Remarks

The only argument allowed to this function is a column. You can use columns containing any type of data, but only numbers are counted. The COUNT function counts rows that contain the following kinds of values:

Numbers
Dates

If the row contains text that cannot be translated into a number, the row is not counted.

When the function finds no rows to count, it returns a blank. When there are rows, but none of them meet the specified criteria, then the function returns 0.

Example

The following example shows how to count the number of numeric values in the column, ShipDate.

=COUNT([ShipDate])

To count logical values or text, use the COUNTA or COUNTAX functions.

Reference

COUNT Function

COUNTA Function

COUNTAX Function

COUNTX Function

Other Resources

Statistical Functions (DAX)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD