CGROUP Function

The CGROUP function returns the total of all cells assigned to a sum group. When specifying the name of the sum group, place the sum group in quotes. The value entered as the sum group must be a constant.

Note: Table cells with the Table Relative option enabled are no longer considered part of the sum group by the CGROUP function. To access cells with the option enabled, use the CGROUPT function.

Syntax

CGROUP("sum group",<argument>)

If the argument is included:

Argument	Result
0	The function returns a count of all cells in the range.
1	The function returns a count of cells in the range that have a non-zero value.
2	The function returns the sum of all cells in the range with non-negative values.
3	The function returns the sum of all cells in the range with negative values.

A cell with a zero value is a cell that is empty or that contains a blank.

Example 1

CGROUP("PY1")

Where PY1 is the name of the sum group. This function returns the value of all cells assigned to the sum group PY1.

A detailed example is available.

Example 2

CGROUP("PY1",0)

Where PY1 is the name of the sum group. This function returns the count of all the cells assigned to the sum group PY1.

Example 3

CGROUP("PY1",3)

Where PY1 is the name of the sum group. This function returns the sum of all cells assigned to the sum group PY1 whose values are negative.