SUMCOLUMN |
Description
Calculates the sum of values in a
column.
Syntax
SUMCOLUMN(number,
column1,
column2, ...)
Number is
the column that contains the values you want to sum. Number must
be a number column.
Column1, column2,... are up to
30 optional columns that define the aggregation context. The sum
is returned for each unique combination
of the group_by columns.
When the result of SUMCOLUMN
is
given as the final value for a new column in a transform worksheet, as
in the example below, each row will get the value of SUMCOLUMN that
corresponds to its particular aggregate values.
If no group_by columns are
provided, the sum of the entire column is returned.
SUMCOLUMN ignores empty values in the column.
Example
In
the following we see
how SUMCOLUMN works with a numeric column and a single aggregation
column. The calculated value is entered in each row.
Sample
Data
Unit
Sales
|
Store
|
=SUMCOLUMN(Unit
Sales,Store) |
NUMBER
|
TEXT
|
NUMBER
|
157
|
West |
157
|
127
|
Central
|
229
|
102
|
Central
|
229
|
353
|
North
|
353
|
104
|
East
|
209
|
105
|
East
|
209
|
|
 User Comments |
 |
|
| Click Here to be the first to post a comment. |
Support Home
| 
Glossary | 
Contact Us 
