COUNT macro

The COUNT macro is available only in HCL® Campaign.

Syntax

COUNT(data)

Parameters

data

The cell range to count the number of cells in. This can be a constant value, a column, a cell range, or an expression evaluating to any of the above. For the format definition of data, see the "Macro Function Parameters" section in the chapter in this guide for your HCL product.

Description

COUNT counts the number of values in the specified data range. It returns a new column containing a single value representing the number of cells containing values within the specified data range.

Note: Counting a blank column returns zero.

Examples


`TEMP = COUNT(AVG(V1:V5))` Creates a new column named `TEMP` containing a single value of one (the function `AVG` returns a single cell in the default mode).
`TEMP = COUNT(V1)` Creates a new column named `TEMP` containing a single value indicating the number of cells containing values in column `V1`.
`TEMP = COUNT(V1:V3)` Creates a new column named `TEMP` containing a single value indicating the number of cells containing values in columns `V1`, `V2`, and `V3`.
`TEMP = COUNT(V1[10:20])` Creates a new column named `TEMP` containing the value `11` (ranges are inclusive), given that the cells all contain values.
`TEMP = COUNT(V1[1:5]:V4)` Creates a new column named `TEMP` containing the value `20` (5 cells in each column times 4 columns = 20 cells), given that all the cells contain values.
`TEMP = COUNT(V1[1:10])` Creates a new column named `TEMP` containing the value `3`, given that rows 1-3 of column `V1` contain values and rows 4-10 are empty.

Related functions


Function	Description
`SUM` or `TOTAL`	Computes the sum of a range of cells