Creates a new column named TEMP containing a single value of one (the function AVG returns a single cell in the default mode).
|
Creates a new column named TEMP containing a single value indicating the number of cells containing values in column V1.
|
Creates a new column named TEMP containing a single value indicating the number of cells containing values in columns V1, V2, and V3.
|
Creates a new column named TEMP containing the value 11 (ranges are inclusive), given that the cells all contain values.
|
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.
|
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.
|
SUM or TOTAL
|
Copyright IBM Corporation 2015. All Rights Reserved.
|