COUNT

Description

Returns the number of values in the supplied list.

Syntax

COUNT ( value_list )

Parameter	Description
value_list	A list of up to 30 comma-separated values or source fields.

Remarks

The list can contain numbers (including 0), logical values, or text representations of numbers.

Source fields can contain only a single value.

Error values or text that cannot be translated into numbers return errors.

If there are no numbers in the list, 0 is returned.

Examples

This function returns 2 (because "Q2" is skipped):

COUNT(5, 6, "Q2")

This function returns 3:

COUNT("03/06/12", "06/21/12", "10/19/12")

Assuming that each source field contains a single numerical value, this function returns 3:

COUNT(S7,S8,S9)