COUNTCOLUMN |
Description
Counts the values in acolumn.
Syntax
COUNTCOLUMN(value,column1, column2, ...)
Value isthe column that contains the values you want to count. Value canbe a text, number, or date column.
Column1, column2,...areup to30 optional columns that define the aggregation context for the count.Counts are calculated for each unique combinationof the group_by columns.
When the result ofCOUNTCOLUMN isgiven as the final value for a new column in a transform worksheet, asin the example below, each row will get the value of COUNTCOLUMN thatcorresponds to its particular aggregate values.
If no group_by columns areprovided, the values are countedacross all rows in the output sheet.
Example
In the following we see how COUNTCOLUMN works with a numeric column and a single aggregation column. The calculated value is entered in each row.
SampleData
UnitSales
| Store
| =COUNTCOLUMN(UnitSales,Store) | NUMBER
| TEXT
| NUMBER
| 157
| West | 1
| 127
| Central
| 2
|
| Central | 2
| 353
| North
| 1
| 104
| East
| 2
| 105
| East
| 2 |
|
 User Comments |
 |
|
| Click Here to be the first to post a comment. |
Support Home
| 
Glossary | 
Contact Us 
